answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi

Add your answer:

Earn +20 pts
Q: How to read and write Excel Files with Perl?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

How can you read and write to files in C programming language?

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.


What is the program to fetch a notepad contents to the Excel sheet using Perl?

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


How do you convert from Excel to open office?

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.


What file systems does Ubuntu support?

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.


Write java program to merge alternate lines from file1 and file2 into file1?

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