How To Open Excel File In C# Windows Application

1. 07-30-2011 #1

   

   Banned

   ---

   Open an Excel file from C

   How do I open an excel file from C?

   

   ---

2. 07-30-2011 #2

   

   Registered User

   ---

   Originally Posted past Sjvlsdsd

   How do I open an excel file from C?

   Run across the stdio library, available on *most* "end-user-programmer" compilers (ie. CL in windows, GCC on Linux, Solaris, or Os X, Cygwin, etc.).

   You'll need to read in the file, and then parse information technology in according with the format MS has already determined (XLS or XLSX, depending on the version). Which isn't followed to spec, 100%, if I call up correctly.

   You can only crack open an excel file in Notepad++ or Gedit or Kate (most text editors less notepad, really), and see the textual data inside - you'll need to parse that to get any "skillful" info out of it. Though if you search the web, I'm sure somebody has already made a parser for XLS and XLSX files, mayhap wait at the code for LibreOffice, every bit that will open XLS and XLSX files quite well.

   

   ---

3. 07-30-2011 #3

   

   Registered User

   ---

   You can relieve the parse worries, if yous export the file from excel, equally plain text. If the evidently text is the data you want, of course, rather than the rest of the Excel file format.

   

   ---

4. 07-30-2011 #4

   

   Registered User

   ---

   Originally Posted by Adak

   You can save the parse worries, if yous export the file from excel, as patently text. If the plain text is the data yous desire, of grade, rather than the rest of the Excel file format.

   Very true, as well, you can export an excel document in CSV format (comma separated values) - which makes parsing using a string tokenizer a complete breeze! That works for data extraction in manifestly text.

   Though if yous want the other stuff, the formatting, the colors, the fonts, all the other "pretty" stuff you see in an excel document, yous'll need to dig a piddling deeper into the file, every bit not all of that can be exported in easy to parse formats.

   

   ---

5. 07-30-2011 #five

   

   Ultraviolence Connoisseur

   ---

   If you actually want to work with Excel documents you're going to have to support diverse different formats of them....for instance Excel 97 and older version do not utilize the new xlsx format. This is really a ZIP file which contains various other files, the content, the images that might be included (thats right there can be images and graphs and all sorts of things) nearly ANYTHING can go into an Excel certificate, we're talking well-nigh Micros*** here...

   So, whats the best answer? Detect an existing library (or use windows existing api for this) to access the files, I HIGHLY propose you do NOT attempt to "parse" it yourself...

   The best phrase you should e'er call up in coding: Practise not re-invent the wheel.
   REUSE existing code, if someone else solved your problem already, they probably solved it a lot better then you lot can in xx minutes hacking something out.

   

   ---

6. 07-30-2011 #half dozen

   

   Registered User

   ---

   If all you demand is to analyze/use/copy/whatsoever the raw data and headers, I 2nd the CSV approach. Between csv format and the std::string, you can practise quite a lot.

   

   ---

7. 07-30-2011 #vii

   

   ATH0

   ---

   Originally Posted past Ocifer

   Between csv format and the std::string, you tin can practice quite a lot.

   std::string is C++, this question is well-nigh C.

   Quzah.

   Hope is the first step on the road to thwarting.

   

   ---

8. 07-xxx-2011 #8

   

   Registered User

   ---

   Microsoft Excel, along with all the other office programs are exposed through COM interfaces. If you actually desire to piece of work with Excel files, vice a vanquish command to open up them or the suggestions given in a higher place, you are going to take to use this interface. Note the .Internet framework does a lot of this for you automatically. Can you create an MFC program with your compiler?

   Originally Posted by anduril462

   Now, please, for the dearest of all things practiced and holy, think nigh what you're doing! Don't just run around willy-nilly, coding like a boozer 2-twelvemonth-old....

   Originally Posted by quzah

   ..... But don't exist surprised when I say y'all aren't using standard C anymore, and equally such,are off in your ain picayune universe that I will completely disregard.

   Warning: Some or all of my posted code may be non-standard and equally such should not be used and in no instance looked at.

   

   ---

9. 07-xxx-2011 #9

   

   &TH of undefined behavior

   ---

   The better mode to do this is to use an existing library (unless you desire to write off a long time writing one from scratch):
   * Utilize COM Automation - Probably the preferred fashion, simply its ugly in C++ and will be hideous in straight C
   * Use an existing open source library. Theres almost certainly one out at that place for excel as Open Office and Gnumeric (etc) tin can handle excel file formats. The one for (older version) word is called "wv" and I don't know what the equivalent is for excel. You would as well need a version for the 2007 format besides as one for the before ones

   The easiest workaround is to do every bit already suggested and force users to save the information in csv starting time.

   

   ---

10. 07-31-2011 #10

    

    Registered User

    ---

    Originally Posted past quzah

    std::string is C++, this question is about C.

    Quzah.

    Right you are, I become between the two boards, forgot where I was. Replace std::cord in my original mail service with string.h, ctype.h and some strtok().

    

    ---

Source: https://cboard.cprogramming.com/c-programming/139925-open-excel-file-c.html

Posted by: rickermordice.blogspot.com

Share this post