What is a simple and reliable C library for working with Excel files? [closed]

by

Strongly discouraged. I’d recommend using a C-friendly format (e.g. CSVs) instead of XLS, or using the new XML formats (take your pick on XML and ZIP libraries).

Still, for a quick fix, you could export to quoted CSV and then import using VBScript. Something like this, although I’d try to get it to work in VBA first.

Note that this will require a copy of Office, and will not scale well (but you can hide the Excel window).

I’ve just found xlsLib, so if you really need to write directly in C, give it a go! Be careful though, because it’s very hard to get right, especially if you’re writing to already-existing files.

There also exists LibExcel, but that’s C++, so you’d need to compile a wrapper around, or rewrite for C.

One final caveat: the reason I didn’t search for these at the start is that it’s extremely difficult to get right. I have not used the libraries above, but I suspect they’ll break in strange and unusual ways. I trust you’ve read Joel’s take on the Office formats.

More Related Contents:

  1. How to pass arguments in __VA_ARGS to a 2d character array? [closed]
  2. Sort words and then the sentence including digits and characters in Shell scripting or perl scripting [closed]
  3. Why does clang produce inefficient asm with -O0 (for this simple floating point sum)?
  4. Casting a function pointer to another type
  5. How to get c code to execute hex machine code?
  6. Trying to understand gcc option -fomit-frame-pointer
  7. difference between sizeof and strlen in c [duplicate]
  8. C – create file in memory
  9. How to compare strings in an “if” statement? [duplicate]
  10. What’s bad about shifting a 32-bit variable 32 bits?
  11. EOF in Windows command prompt doesn’t terminate input stream
  12. EPPlus number format
  13. Calling a FORTRAN subroutine from C
  14. What are the useful GCC flags for C?
  15. How does the strlen function work internally?
  16. Anonymous functions using GCC statement expressions
  17. C – trying to read a single char from stdin (and failing) w/ scanf / getchar
  18. Which C datatype can represent a 40-bit binary number?
  19. Compound condition in C: if (0.0 < a < 1.0)
  20. Do threads have a distinct heap?
  21. Linking a C program directly with ld fails with undefined reference to `__libc_csu_fini`
  22. How is a CRC32 checksum calculated?
  23. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  24. Why does my compiler not accept fork(), despite my inclusion of ?
  25. Intersection of two lines defined in (rho/theta ) parameterization
  26. How do you use offsetof() on a struct?
  27. How to concatenate string and int in C?
  28. How to compile and run C in sublime text 3?
  29. why gets() is not working?
  30. QuickSort and Hoare Partition

Leave a Comment