By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

How do i extract data from an excel file and use it in a c program?

P: 2
I have data (a 2D array) in Excel. I need to import the data to my program in C and use it in the logic. Then I also want to store my final answer in another excel file.
How do i go about this?
Jan 16 '16 #1
Share this Question
Share on Google+
3 Replies


weaknessforcats
Expert Mod 5K+
P: 9,197
You will need to export your Excel spreadsheet to a file and read that file into your C program. The C program can output the result in a file format readable by Excel.

In Excel, select File then Export and then choose the file format you wish to use. (Excel 2016).
Jan 17 '16 #2

P: 2
By file do you mean a .txt file?
Jan 18 '16 #3

weaknessforcats
Expert Mod 5K+
P: 9,197
A .txt file is one option. There is also the .csv file for comma-separated-values. A .csv file is handy because all the values ae between commas so you can parse the file in the C program.

Check your Excel export file types options.
Jan 18 '16 #4

Post your reply

Sign in to post your reply or Sign up for a free account.