Dear all,

under OSx 10.12.5 after doing: perl -v I´ve got:

This is perl 5, version 24, subversion 1 (v5.24.1) built for darwin-thread-multi-2level

Then I´ll do
git clone https://github.com/VSRonin/QtXlsxWriter.git
qmake
make

After a while it says:

make[3]: *** No rule to make target ../../../../qt-everywhere-opensource-src-5.9.1/qtbase/include/QtXlsx/qtxlsxversion.h', needed by /qt-everywhere-opensource-src-5.9.1/qtbase/lib/QtXlsx.framework/Versions/0/Headers/qtxlsxversion.h'. Stop.
make[2]: *** [release-all] Error 2
make[1]: *** [sub-xlsx-make_first] Error 2
make: *** [sub-src-make_first] Error 2

What´s the problem?

Thanks.

Best,

W

Many errors trying to work with Qt 6.0.1. Any plans to support Qt 6?

Thanks

I checkout develop branch for using comment function. But there are always errors. Excel xlsx files was broken after writing comment.

excel单元格中遇到windows换行符（\r\n），读出来就变成_x000D_，请问怎么解决？

Found during testing.

file : examples/image/main.cpp

boox2.xlsx is not saved normally.

It seems wrong.

Greetings - I'm trying to automate the creation of a chart. I can Bar Charts, Scatter, Pie charts with no problem. However, any Line chart cause and error upon loading the spreadsheet reported as "We found a problem with some content in SPREADSHEET_NAME. Do you want us to recover? YES/NO". There appears to be a mal-configuration in the underlying XML file.

This works fine -->
QXlsx::Chart *bar3DChart = xlsxDoc.insertChart(65, 4, QSize(300, 300));
bar3DChart->setChartType(QXlsx::Chart::CT_Bar3D);
bar3DChart->addSeries(QXlsx::CellRange("A50:C59"));

This causes some sort of corruption -->
QXlsx::Chart *line3DChart = xlsxDoc.insertChart(85, 4, QSize(300, 300));
line3DChart->setChartType(QXlsx::Chart::CT_Line);
line3DChart->addSeries(QXlsx::CellRange("A50:C59"));

Does anyone have any suggestions?

Thanks much!

Calling insertImage() or insertChart() leads to creating corrupted file. Microsoft Excel shows warning when trying to open file: "We found a problem with some content in 'filename.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." Clicking 'Yes' results in an empty file.
dbzhang800's code works fine, except for QList/QVector thing in xlsxzipreader.cpp.

VSRonin
I have tried your branch of QtXlsxWriter and Qtexcel .
Both projects have problem that the excel file will be damaged when written something to a exist file .The red mark will be lose in below PIC by QtXlsxWriter and Qtexcel

I copy code from projects QtXlsxWriter and Qtexcel and add some code also.
Now some bug are fixed .
I want to patch your project or QtExcel but failed many times.
So i made a new branch on https://github.com/liufeijin/littleQXlsx
below is the the test file and my code zip file
test.xlsx
QXlsx.zip

if you have free time to patch your project , will be great!

currently CMake build requires Qt 5.5 and above

Thanks so much for this library.

Is it possible to set the colour of a worksheet tab? If not, is it something you intend to implement?

Thank you.

Hello,

I'm having issues building the source code.
When il use mingw32-make, I'm getting several errors :

cd src\ && ( if not exist Makefile C:\User\U526413\Documents\DevPlugins_PLUGINS_LIBS\Qt-5.6.2bis\bin\qmake C:\User\U526413\Documents\DevPlugins_PLUGINS_LIBS\Qt-5.6.2bis\include\QtXlsxWriter-master
\src\src.pro -o Makefile ) && C:/MinGW/bin/mingw32-make -f Makefile
mingw32-make[1]: Entering directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src'
cd xlsx\ && ( if not exist Makefile C:\User\U526413\Documents\DevPlugins_PLUGINS_LIBS\Qt-5.6.2bis\bin\qmake C:\User\U526413\Documents\DevPlugins_PLUGINS_LIBS\Qt-5.6.2bis\include\QtXlsxWriter-maste
r\src\xlsx\xlsx.pro -o Makefile ) && C:/MinGW/bin/mingw32-make -f Makefile
Project MESSAGE: perl -w C:\User\U526413\Documents\DevPlugins_PLUGINS_LIBS\Qt-5.6.2bis\bin\syncqt.pl -module QtXlsx -version 0.3.0 -outdir C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.
2bis/include/QtXlsxWriter-master C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master
= C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master
= C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master
QtXlsx: created fwd-include header(s) for /src/xlsx/ { xlsxabstractooxmlfile.h (1), xlsxabstractooxmlfile_p.h (1), xlsxabstractsheet.h (1), xlsxabstractsheet_p.h (1), xlsxcell.h (1), xlsxcell
_p.h (1), xlsxcellformula.h (1), xlsxcellformula_p.h (1), xlsxcellrange.h (1), xlsxcellreference.h (1), xlsxchart.h (1), xlsxchart_p.h (1), xlsxchartsheet.h (1), xlsxchartsheet_p.h (1), xlsxcolor_p.h
(1), xlsxconditionalformatting.h (1), xlsxconditionalformatting_p.h (1), xlsxcontenttypes_p.h (1), xlsxdatavalidation.h (1), xlsxdatavalidation_p.h (1), xlsxdocpropsapp_p.h (1), xlsxdocpropscore_p.h (
1), xlsxdocument.h (1), xlsxdocument_p.h (1), xlsxdrawing_p.h (1), xlsxdrawinganchor_p.h (1), xlsxformat.h (1), xlsxformat_p.h (1), xlsxglobal.h (1), xlsxmediafile_p.h (1), xlsxnumformatparser_p.h (1)
, xlsxrelationships_p.h (1), xlsxrichstring.h (1), xlsxrichstring_p.h (1), xlsxsharedstrings_p.h (1), xlsxsimpleooxmlfile_p.h (1), xlsxstyles_p.h (1), xlsxtheme_p.h (1), xlsxutility_p.h (1), xlsxworkb
ook.h (1), xlsxworkbook_p.h (1), xlsxworksheet.h (1), xlsxworksheet_p.h (1), xlsxzipreader_p.h (1), xlsxzipwriter_p.h (1) }
QtXlsx: created version header
QtXlsx: created master header
QtXlsx: created headers.pri file
mingw32-make[2]: Entering directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src/xlsx'
C:/MinGW/bin/mingw32-make -f Makefile.Debug all
mingw32-make[3]: Entering directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src/xlsx'
Makefile.Debug:198: *** missing separator. Stop.
mingw32-make[3]: Leaving directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src/xlsx'
Makefile:40: recipe for target 'debug-all' failed
mingw32-make[2]: *** [debug-all] Error 2
mingw32-make[2]: Leaving directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src/xlsx'
Makefile:40: recipe for target 'sub-xlsx-make_first' failed
mingw32-make[1]: *** [sub-xlsx-make_first] Error 2
mingw32-make[1]: Leaving directory 'C:/User/U526413/Documents/DevPlugins/_PLUGINS/_LIBS/Qt-5.6.2bis/include/QtXlsxWriter-master/src'
Makefile:42: recipe for target 'sub-src-make_first' failed
mingw32-make: *** [sub-src-make_first] Error 2

Maybe I missed something?

Thank you

Is that possible to select range and assign style to that?
I need to mark several cells as a table.

im testing the library and the read function dont seems to work ... the cellAt() function give me NULL pointer to

I can read from .xlsm file as good as from .xlsx, but when I write some data in my .xlsm and save it, it breaks and i can't open it. Can I rewrite/make .xlms file with your library?

Is there any way to use the pre defined excel styles for a cell?

I tried to import it into my vs project, but there was an error.
But in QT creator, it's normal.

qtxlsx.pro builded by qt5.9 MINGW qtcreator (perl 5 ,version 24,subversion 0(v5.24.0)) in windows, but failed,
the error is "sub-hello-qmake_all"

Have just started using QtXlsx ( ! nice job ! ) but am having some issues. It is likely that I will be able to fix some of them but almost certainly not all of them. Please let me know what level of interest there would be in addressing some of these. They may be related to known issues, but I couldn't find any relevant info. There may also be existing work-arounds, in which case I'd be thrilled to learn of them.

1. At present, the package only supports "int" integer values from spreadsheets - Excel supports "long long" integers. This can be resolved by a simple change in xlsxworksheet.cpp. In the routine WorksheetPrivate::loadXmlColumnsInfo, the QVariant cell value is set with

cell->d_func()->value = value.toInt();

Changing that to

cell->d_func()->value = value.toLongLong();

resolves the big integer problem.

2. Formulas don't seem to be working correctly. There is a fair bit of code to deal with them, but as near as I can tell, formulas are effectively just ignored.

3. DateTime values are also not dealt with effectively. I figured out a workaround by noting which actual "double" values are really days through the cell format (isDateTimeFormat() seems correct).

4. Generally, the output file from QtXlsx is not readable by Excel. Excel reports that there are errors (apparently in the sheetn.xml parts), which can coarsely be fixed. The fixes are not perfect, but has let me continue to make some progress in my present tasks.

Thanks

1.I clone this code from github ;
2.Use this CMD install this library
()
3.use command
qmake
mingw32-make
mingw32-make install
to finish the install
4.add QT += xlsx in my .pro file
5.run the test code

6.Cant run and the error info like this:

So how can I solve this problem ,Thanks a lot !

I want to read and write Xlsx-Files with Qt and use the QXlsx module: http://qtxlsx.debao.me/
While I can write into xlsx-files, read does not work
I copied this example into my code http://qtxlsx.debao.me/qtxlsx-extractdata-main-cpp.html

`{
//Create a new .xlsx file.
QXlsx::Document xlsx;
xlsx.write("A1", "Hello Qt!");
xlsx.write("A2", 12345);
xlsx.write("A3", "=44+33");
xlsx.write("A4", true);
xlsx.write("A5", "http://qt-project.org");
xlsx.write("A6", QDate(2013, 12, 27));
xlsx.write("A7", QTime(6, 30));
xlsx.saveAs("Book1.xlsx");
}

QXlsx::Document xlsx("Book1.xlsx");

qDebug()<<xlsx.read("A1");
qDebug()<<xlsx.read("A2");
qDebug()<<xlsx.read("A3");
qDebug()<<xlsx.read("A4");
qDebug()<<xlsx.read("A5");
qDebug()<<xlsx.read("A6");
qDebug()<<xlsx.read("A7");

for (int row=1; row<10; ++row) {
if (QXlsx::Cell *cell=xlsx.cellAt(row, 1))
qDebug()<value();
}`

and in my headerfile I added the line:

`#include "xlsx/xlsxdocument.h"

The output I get is:

QVariant(Invalid)

Can anyone help me?
Thanks

XLSM type file contains VBA .
if write it the VBA will lose as below red mark

the vbProject.bin is lost in xlsm zip file
cloud you fix it?
Many thanks

I write a formular in worksheet, but how can read the reality result when the cell has fomular? If the cell has formular, does it only can output formular string?

I want to build and get .so file in linux, pls tell me a little,thanks!

使用此最新库，读取xlsx文件中的计算公式，读出的并非数值，而是类似“=SUM(O3:V3)”，类似这样的字符串，但excel展示的是某计算后的数值。请问库完成计算公式功能了吗？还是存在此BUG？

I need to get image store in a cell of excel file. How can do that?

Thansk

Hello, pretty much the title, how can I edit an existing .xlsx file using QtXlsxWriter.

Sorry english is not my native langage so, if you want more explanation feel free to ask.

Thank you to update this usefull addon. Hope you can help me quickly because i need to finished my project in 2 weeks.

centos 7,Qt5.9.0.
succeed with qmake,but "make" failed,it show "g++:error:unrecognized command line option '-std=c++1z"

Hello everyone! Really happy about something like QXlsx existing but it seems to have an issue when modifying an existing file.

I have this template I made so I can modify it when needed and save it as a new file, but it seems that when loading it, QXlsx resets the style on my premade charts. (The template exists in first place so I can just insert data using code and the user can visualize the info dump later in the xlsx)

Is there a way around this or a fix coming?
Is there a way I can contribute to help fixing this? (As it is in my best interest)

Template:

Modified:

Thanks in advance!