Skip to content
#

xlsx

Here are 587 public repositories matching this topic...

sheetjs

使用spring boot打造文件文档在线预览项目解决方案,支持doc、docx、ppt、pptx、xls、xlsx、zip、rar、mp4,mp3以及众多类文本如txt、html、xml、java、properties、sql、js、md、json、conf、ini、vue、php、py、bat、gitignore等文件在线预览

  • Updated Jun 30, 2020
  • Java
freb
freb commented Apr 27, 2020

When creating a document, things get a little annoying once you start working with tables. I think one of the main annoyances is that once you have a table in the document, you cannot continue adding content after you've inserted the table. Instead you have to do something like:

p1 := doc.AddParagraph()
pAfterTable := doc.InsertParagraphAfter(p1)
table := doc.InsertTableAfter(p1)

//
jkyeung
jkyeung commented Apr 7, 2020

This is motivated by the weirdness that is Excel's "center across selection". After playing around with Excel for a bit, I now understand how this works. And it makes complete sense that it is achieved in XlsxWriter the way it is.

However, I think it would be nice to have an additional worksheet method which makes it easier. I was thinking format_range, which would be somewhat like `merge_ran

DocumentServer
zjs-apple
zjs-apple commented Apr 30, 2020

When i Installing Document Server for Linux on CentOS7.5.
Reference:https://helpcenter.onlyoffice.com/server/linux/document/linux-installation-centos.aspx
In the end,the document server is ok,
but When I test editing files,
ws://XXXX/5.5.1-76/doc/b81fdff747a247929253f4701a92bc521588227954180/c/208/zp1umjpc/websocket
This link has been pending.
Centos7.5:port all open,firewall is closed.
Wha

aneuway2
aneuway2 commented Dec 9, 2019

I recently ran into an issue where hidden rows/columns were nto being read.

From this I stumbled upon pyexcel/pyexcel#53 which gave me the answer to use skip_hidden_row_and_column like so:

from pyexcel_xlsx import get_data
data = get_data("file.xlsx", skip_hidden_row_and_column=False)

This however is not documented anywhere that I could find (and I'd

DesktopEditors
parrenin
parrenin commented Feb 26, 2020

Do you want to request a feature or report a bug?
Request a feature.
What is the current behavior?
The equation editor of OnlyOffice generally uses LaTex shortcuts, which is good.
But the \frac shortcut for creating fractions does not work.
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

**What is the ex

tlouwers
tlouwers commented Feb 10, 2020

When I try to open a sample xslx file, which has a sheet in it with an embedded PowerPoint, I get the following exception: xlnt::exception : missing global header signature

If there are more sheets in it, none of them can be handled as loading the xslx file fails with that exception. I was wondering if there is a way to still be able to read the other sheets, simply ignoring the sheets which

bernardoccordeiro
bernardoccordeiro commented Dec 4, 2019

While using rows for a project, could not use the import_from_pdf function after putting rows as a dependency. The solution, ultimately, was to also include PyMuPDF and cached_property as dependencies for my project, so as to enable the pdf plugin for rows. This information, however, is not clear by looking only at the docs. It would be desirable to list the dependencies for each plugi

petricf
petricf commented Jan 21, 2020

This guide is dated January 21st, 2020.

Assumptions:

  • Qt is/will be installed to C:\Qt
  • Project directory (location of unpacked zlib and libxlsxwriter) is C:\Projects
  • Install destination of compiled zlib will be C:\Qt\Tools\zlib(32/64)
  • Install destination of compiled libxlsxwriter will be C:\Qt\Tools\xlsxwriter(32/64)

Prerequisites:

  • Installed Qt + Qt-Creator, selected packag
dawaltconley
dawaltconley commented Oct 22, 2019

Per the documentation, if I create a new file from an encrypted workbook, the new file will not be encrypted.

xlsx.fromFileAsync('template.xlsx', { password: 'S3cret!' })
    .then(wb => {
        // do some stuff
        return wb.toFileAsync('new-file.xlsx') // not encrypted
    })

However, if the source file also requires a password to modify, then the file created by xlsx-p

Funth0mas
Funth0mas commented Mar 3, 2019

So that we can setup mypy on CI we need to elliminate all errors. Currently all serious mypy errors are in canmatrix.canmatrix and most of them are bound to float_factory playing with attrs.

The problem is, that mypy currently only undertsand attr converters, if they are named functions. That means NEITHER converter=decimal.Decimal NOR converter=CanId.from_compound_integer.

Improve this page

Add a description, image, and links to the xlsx topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the xlsx topic, visit your repo's landing page and select "manage topics."

Learn more

You can’t perform that action at this time.