StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Strongly discouraged. I'd recommend using a C-friendly format (e.g. CSVs) instead of XLS, or using the new <a href="http://msdn.microsoft.com/en-us/library/aa338205.aspx" rel="noreferrer">XML</a> formats (take your pick on XML and ZIP libraries).</p> <p>Still, for a quick fix, you could export to quoted CSV and then import using <a href="http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/" rel="noreferrer">VBScript</a>. Something like <a href="http://ourworld.compuserve.com/homepages/guenter_born/wshbazaar/WSHExcel1.htm" rel="noreferrer">this</a>, although I'd try to get it to work in VBA first.</p> <p>Note that this will require a copy of Office, and will not scale well (but you <em>can</em> hide the Excel window).</p> <hr> <p>I've just found <a href="http://xlslib.sourceforge.net/" rel="noreferrer">xlsLib</a>, 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.</p> <p>There also exists <a href="http://www.libexcel.com/" rel="noreferrer">LibExcel</a>, but that's C++, so you'd need to compile a wrapper around, or rewrite for C.</p> <hr> <p>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 <a href="http://www.joelonsoftware.com/items/2008/02/19.html" rel="noreferrer">Joel's</a> take on the Office formats.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload