Microsoft .xls files are a proprietary file format, which means you need one of these options:
Write the program as a VBA macro within excel itself.
Pay Microsoft some money to get the appropriate SDK which would allow you to access .xls files in a meaningful manner.
Spend months / years reverse engineering the .xls file format, only for Microsoft to change it in some way with the next version of excel.
Grab the source code for open office. OpenOffice does a pretty good job of importing and exporting .xls files, so finding out how it does it may be worth while. This too would require a long period of research.
Or perhaps take an easier approach and get excel to save the file as a .csv file, which you then process to yield another .csv file for import back into excel. CSV files are just text files, which are very easy to process from a C program.
I believe the really new versions of excel also use XML as a text format for saving files, with the advantage that all the formatting information is also preserved as well. It too is easy to parse from a C program.
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...