QXlsx

QXlsx copied to clipboard

after selected sheet for writing or reading, many sheets of the excel are be set to selected i can't find where is the bug, so make circle loop to set...

liufeijin

added checking of ptr before it was dereferenced

1

Hi! I found potential bug, currentWorksheet() can return nullptr, it follows that the pointer must be checked before it was uses

ProjectMutilation

QXlsx can't even be compiled for Qt4 and there where still some Qt4 leftovers. This adds basic QStringView usage where it makes sense.

dantti

Handling Excel file with a large amount of rows

1

I am just experimenting with the QXlsx-Library concerning a large amount of rows. Code: ``` QXlsx::Document* oDocument = new QXlsx::Document(); for (int column = 1; column saveAs("C:\\Temp\\big.xlsx"); delete oDocument; oDocument...

PMime

littleblackdot

rhddlr

when open big excel file, it cost much time in create and release object, How to reduce time consumption

1

version: [0461eac] ```c++ // create object const std::unique_ptr xlsx = std::make_unique(filePath); // write some cell // save object xlsx->saveAs(filePath); // release ``` when open 200KB excel file: create object: 2106ms...

rhddlr

``` QXlsx::Format format; if(fg){format = cell->format();} format.setFont(newfont); format.setPatternBackgroundColor(QColor(255,00,200)); xlsx.write(i, j, value, format); ``` in this code, I try to re-format the cell. if fg is true, setfont will not work...

juneleung

I read the excel cells and the text will bring more text with rPh, rPr, and so on... which is more than the normal display in excel... how to avoid...

juneleung

Hello, It's possible to define a name of a cell. I didn't find how to read a cell using a defined name. How is it possible to retrieve all defined...

stslu