search

brechtsanders / xlsxio

XLSX I/O - C library for reading and writing .xlsx files
MIT License
417 stars 112 forks source link

Is it possible to write a file with multiple sheets? #52

Closed kekersdev closed 5 years ago

kekersdev commented 5 years ago

I've tried to use xlsxiowrite_open with the same file name and different sheet name but it recreates (i think) the file with one sheet with that different name

brechtsanders commented 5 years ago

correct. writing creates a file. it does not read/merge what was already there. if you want multiple sheets you need to create the file once with multiple sheets.

kekersdev commented 5 years ago

Great, but how do i do that?

kekersdev commented 5 years ago

And also how do i refer to specific sheet in file

brechtsanders commented 5 years ago

Sorry, my mistake, this feature is not in the library yet. Currently it only writes 1 sheet.

When reading xlsxioread_sheet_open() selects a specific sheet for reading, please see examples/example_xlsxio_read.c for an example.

kekersdev commented 5 years ago

Ok, now i understand, thank you