Hi friends,
I don't know how to open, read and write to excel sheet with C code
Printable View
Hi friends,
I don't know how to open, read and write to excel sheet with C code
Take a look at microsoft sites.
Probably the same way that this other poster was after MS .DOC files
http://cboard.cprogramming.com/showthread.php?t=75085
exactly as that thread said, there is a lot of additional formatting
involved with document types other than .txt, but i found that
you can write to an excel file just as you write to a text file, using
fprintf. your ability to control excel from within a C program is
fairly limited unless you learn how to program formatting info in
as well (which would be quite complex), but if you had a program
that needed to log outputs for some calculation, i found that you
can write to a spreadsheet - \n will move your destination cell to
the one below the current cell, \t will move it to the cell on the
right. this may be somewhat useful to you, but as far as reading
in from a spreadsheet in C, you're on your own
I agree, given than excel can readily import tab or comma separated data from text files (I've done this many times), the amount of work it would take to generate a .xls file manually (without Microsoft's API) seems prohibitive.