http://search.cpan.org/~jdb/Win32-OLE-0.1709/lib/Win32/OLE.pm This link has a great example of accessing the Excel API using Perl.
Chat with our AI personalities
We can read and write to files with the help of file commands in c programming.There are so many commands related to file for read,write,append,delete etc.
When you ask questions like this, you need to specify what format your data is in. A common format is CSV. I believe that Excel accepts CSV format. Maybe if you write your file in CSV and change it from yourfile.txt to yourfile.csv, then Excel will be able to read it properly. Or maybe you'll have to search through the Excel options for CSV. If I'm wrong and Excel can't read CSV, then I for one have no idea what Excel's format is like. CSV is quite simple. You write out each row of the spreadsheet as a line of text, and you separate the columns using commas. Example: Year,Sales,Profit 2006,42018,6320 2007,44619,7706 2008,47328,9584 2009,41621,-800
Save your file as Excel xls format. Use the File-->Save As... menu and select the file type in the save dialog. For a video How to, see related links.
Ubuntu supports a large number of file systems, including ext2 (read/write), ext3 (read/write), ext4 (read/write), ReiserFS (read/write), JFS (read/write), XFS (read/write), FAT (read/write), and NTFS (read, additional software available for writing). With the exception of NTFS, it can also boot off of the above file systems.
I suggest something like this:* Open file1 and file2 * Create a temporary output file, for writing * Read a line from file1, write it into the output file * Read a line from file2, write it into the output file * Repeat the previous two steps, while you are not at end-of-file in either of the two files * At this point, if you are NOT at end-of-file in file1, read the remaining lines of file1, and write them to the output (you can write a loop for this). * Similarly, if you are NOT at end-of-file in file2, read and write the remaining file. * Close file1, file2, and the output file. * Copy the temporary output file back to file1 * Erase the temporary output file