Re: Math Solver

To expand on Cody Pendant's suggestion - you can use Spreadsheet::WriteExcel and Spreadsheet::ParseExcel to automate the communication. Or, if you're on a windows machine, you can use the various Win32:: and OLE:: modules to talk directly to Excel.

------
We are the carpenters and bricklayers of the Information Age.

Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

Comment on Re: Math Solver

Replies are listed 'Best First'.
Re: Re: Math Solver by deobfuscated (Initiate) on Jul 02, 2003 at 03:09 UTC
perhaps if excel is the destination grab an xml-formatted copy of an excel spreadsheet, gut it, then borrow its functionality to reproduce it.	[reply]
Re: Re: Re: Math Solver by dragonchild (Archbishop) on Jul 07, 2003 at 15:25 UTC
Uh, no. That's a bad plan. You're assuming that Microsoft wants to keep anything in their applications similar from version to version. Microsoft has a vested interest in not maintaining outside compatibility between versions. That way, you have to use their software. Better is to use the modules whose maintainers are willing to handle this issue. If you want, write a XLS -> XML converter, using Spreadsheet::WriteExcel and your favorite XML writer. At least, you'll know that the DTD won't change just cause the version of Excel you saved the file in changed. ------ We are the carpenters and bricklayers of the Information Age. Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement. Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.	[reply]