github-starred/libxlsxwriter

Fork 0

mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00

[GH-ISSUE #255] Corrupted EXCEL file #202

New issue

Closed

opened 2026-05-05 11:54:48 -06:00 by gitea-mirror · 7 comments

gitea-mirror commented

2026-05-05 11:54:48 -06:00

Owner

Originally created by @hadrizi on GitHub (Dec 12, 2019).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/255

Originally assigned to: @jmcnamara on GitHub.

I am using libxlsxwriter to make DOS txt parser.
But when i tried to build an application for Windows it compiled with no errors, and when I opened my excel file I got this message

Excel could not open file.xlsx because some content is unreadable. Do you want to open and repair this workbook.

so most of my data was missed.
So i tried to write small example code and chek if problem appears again and it does.
I am using Visual Studio 2017, libxlsxwriter was built according to this guide, my OS is Windows 10
Here is small code i tried to compile:

#include "xlsxwriter.h"

struct header
{
	char name[256];
};

struct header hd = { "hey" };

int main() {
	lxw_workbook  *workbook = workbook_new("hello_world.xlsx");
	lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

	lxw_row_t r = 0;
	lxw_col_t c = 0;
	
	worksheet_write_string(worksheet, r, c, hd.name, NULL);
	
	return workbook_close(workbook);;
}

P.S here is the code I compiled on Ubuntu 18.04. Sorry it is in Russian, but there is only one code file in src folder.

Originally created by @hadrizi on GitHub (Dec 12, 2019). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/255 Originally assigned to: @jmcnamara on GitHub. I am using libxlsxwriter to make DOS txt parser. But when i tried to build an application for Windows it compiled with no errors, and when I opened my excel file I got this message ``` Excel could not open file.xlsx because some content is unreadable. Do you want to open and repair this workbook. ``` so most of my data was missed. So i tried to write small example code and chek if problem appears again and it does. I am using Visual Studio 2017, libxlsxwriter was built according to [this guide](https://libxlsxwriter.github.io/getting_started.html#gsg_vcpkg), my OS is Windows 10 Here is small code i tried to compile: ``` #include "xlsxwriter.h" struct header { char name[256]; }; struct header hd = { "hey" }; int main() { lxw_workbook *workbook = workbook_new("hello_world.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_row_t r = 0; lxw_col_t c = 0; worksheet_write_string(worksheet, r, c, hd.name, NULL); return workbook_close(workbook);; } ``` P.S [here](https://github.com/hadrizi/tArass) is the code I compiled on Ubuntu 18.04. Sorry it is in Russian, but there is only one code file in src folder.

gitea-mirror

2026-05-05 11:54:48 -06:00

closed this issue
added the
question

awaiting user feedback
labels

gitea-mirror commented

2026-05-05 11:54:55 -06:00

Author

Owner

@jmcnamara commented on GitHub (Dec 12, 2019):

So i tried to write small example code and chek if problem appears again and it does.

That source file doesn't have any issues:

I also ran the tArass file with the Readme.md file as input and that worked fine as well:

The issue is probably that you are processing a file that isn't UTF-8 encoded. All strings passed to libxlsxwriter (and Excel) must be UTF8 encoded. Do you think that may be your issue?

@jmcnamara commented on GitHub (Dec 12, 2019): > So i tried to write small example code and chek if problem appears again and it does. That source file doesn't have any issues: ![screenshot](https://user-images.githubusercontent.com/94267/70747474-fdf36580-1d1f-11ea-92fa-5cddbc9fbb3a.png) I also ran the tArass file with the Readme.md file as input and that worked fine as well: ![screenshot](https://user-images.githubusercontent.com/94267/70747689-68a4a100-1d20-11ea-9202-02a80192f6a4.png) The issue is probably that you are processing a file that isn't UTF-8 encoded. All strings passed to libxlsxwriter (and Excel) must be UTF8 encoded. Do you think that may be your issue?

gitea-mirror commented

2026-05-05 11:54:58 -06:00

Author

Owner

@hadrizi commented on GitHub (Dec 12, 2019):

@jmcnamara hm, this is strange I reloaded my PC and smaller code started to work. But tArass still doesn't work.
Here is file I'm parsing.

and it seems that file is UTF-8 encoded

@hadrizi commented on GitHub (Dec 12, 2019): @jmcnamara hm, this is strange I reloaded my PC and smaller code started to work. But tArass still doesn't work. Here is [file](https://drive.google.com/open?id=1-HFXBmlTOalRvlMrf4jsfTbcD9Ir98a_) I'm parsing. ![tarass bug](https://raw.githubusercontent.com/hadrizi/tArass/master/assets/bug.gif "tarass bug") and it seems that file is UTF-8 encoded ![utf8](https://raw.githubusercontent.com/hadrizi/tArass/master/assets/utf8.PNG "utf8")

gitea-mirror commented

2026-05-05 11:55:00 -06:00

Author

Owner

@RaFaeL-NN commented on GitHub (Dec 12, 2019):

А строки ""Выполняемая команда" и т.п. в worksheet_merge_range ты точно в UTF-8 передаешь? Файл xlsx на выходе прикрепи, его можно распаковать и посмотреть, что там не нравится Excel

@RaFaeL-NN commented on GitHub (Dec 12, 2019): А строки ""Выполняемая команда" и т.п. в worksheet_merge_range ты точно в UTF-8 передаешь? Файл xlsx на выходе прикрепи, его можно распаковать и посмотреть, что там не нравится Excel

gitea-mirror commented

2026-05-05 11:55:04 -06:00

Author

Owner

@hadrizi commented on GitHub (Dec 12, 2019):

А строки ""Выполняемая команда" и т.п. в worksheet_merge_range ты точно в UTF-8 передаешь?

Вот так я их передаю

Файл xlsx на выходе прикрепи, его можно распаковать и посмотреть, что там не нравится Excel

а вот сам xlsx файл

@hadrizi commented on GitHub (Dec 12, 2019): > А строки ""Выполняемая команда" и т.п. в worksheet_merge_range ты точно в UTF-8 передаешь? Вот так я их передаю ![code_piece](https://raw.githubusercontent.com/hadrizi/tArass/master/assets/code_piece.PNG "code_piece") > Файл xlsx на выходе прикрепи, его можно распаковать и посмотреть, что там не нравится Excel а вот сам xlsx [файл](https://drive.google.com/open?id=1sgndnqIlderrQzlZ4c7GDzFgzhcbjga8)

gitea-mirror commented

2026-05-05 11:55:07 -06:00

Author

Owner

@RaFaeL-NN commented on GitHub (Dec 12, 2019):

Строки ты передаешь в Win-1251, поэтому файл на выходе битый. Надо передавать в UTF-8. Я не знаю как это сделать в VS (не программист на С), возможно какой-то параметр сборки проекта. Либо использовать функции перекодирования MultiByteToWideChar/WideCharToMultiByte. Замени временно все русские строки на пустые либо транслитерируй их и увидишь, что дело в этом

@RaFaeL-NN commented on GitHub (Dec 12, 2019): Строки ты передаешь в Win-1251, поэтому файл на выходе битый. Надо передавать в UTF-8. Я не знаю как это сделать в VS (не программист на С), возможно какой-то параметр сборки проекта. Либо использовать функции перекодирования MultiByteToWideChar/WideCharToMultiByte. Замени временно все русские строки на пустые либо транслитерируй их и увидишь, что дело в этом

gitea-mirror commented

2026-05-05 11:55:09 -06:00

Author

Owner

@hadrizi commented on GitHub (Dec 13, 2019):

Строки ты передаешь в Win-1251, поэтому файл на выходе битый.

Да, так оно и есть. Я просто поменял кодировку исходника, собрал и все сработало.

@hadrizi commented on GitHub (Dec 13, 2019): > Строки ты передаешь в Win-1251, поэтому файл на выходе битый. Да, так оно и есть. Я просто поменял кодировку исходника, собрал и все сработало.

gitea-mirror commented

2026-05-05 11:55:11 -06:00

Author

Owner

@jmcnamara commented on GitHub (Dec 13, 2019):

@RaFaeL-NN Спасибо за помощь

@jmcnamara commented on GitHub (Dec 13, 2019): @RaFaeL-NN Спасибо за помощь