PERL Modules - Control file format in Spreadsheet::WriteExcel?

Author

Control file format in Spreadsheet::WriteExcel?

Kelly Huennekens

2004-05-12, 7:20 pm

Does anyone know if it's possible to control the specific file type
created using the module Spreadsheet::WriteExcel? I am using the
module to create a new Excel file, and I need that file to be of type
DBF 4 (dBASE IV). Creating the file as one with a .dbf extension
rather than .xls does not do the job. Or if there is any other way to
solve this problem programmatically that anyone can think of, please
let me know. Thanks!

John McNamara

2004-05-12, 7:20 pm

Kelly Huennekens wrote:

> Does anyone know if it's possible to control the specific file type
> created using the module Spreadsheet::WriteExcel? I am using the
> module to create a new Excel file, and I need that file to be of type
> DBF 4 (dBASE IV).

Spreadsheet::WriteExcel only supports the Excel binary format.

dBASE IV is just a DB format that Excel translates to when you use the
"save as DBF 4" option.

You should be able to use the DBD::XBase module to create a dBASE
file:

http://search.cpan.org/~janpaz/DBD-XBase/

John.
--

Sponsored Links