2

I have an excel 2010 file (xlsx) with a sheet of data and a sheet with pivot table using that data. I would like to write a perl code that can change the data, and then the pivot table would be changed automaticly according to the new data.

I'm using perl packages: Spreadsheet::ParseExcel::Worksheet Spreadsheet::ParseExcel::SaveParser Excel::Writer::XLSX Spreadsheet::WriteExcel

How can I do it? Do I need another package?

Thanks

Paul Sweatte
  • 24,148
  • 7
  • 127
  • 265
user3428288
  • 21
  • 1

1 Answers1

0

Use DBD:CSV and DBIx:SQLCrosstab:

References

Paul Sweatte
  • 24,148
  • 7
  • 127
  • 265