apparently win32::OLE can be used to write to an existing spreadsheet. I have
read the cpan docs and tried a hundred things, but I cant seem to get the
syntax right.
I'm going to post this script one more time.
#!/usr/bin/perl
use strict;
use Spreadsheet::XLSX;
use File::Copy;
use Win32::OLE;
ok so I figured out that Spreadsheet::writeExcel only writes new spreadsheets
and that its difficult to overwrite cells or append them in an existing
spreadsheet.
Is there a module out there that I can use to do what I'm trying to do?
I have written a script which uses Spreadsheet::xlsx to pull
I have written a script for updating and modifying a price list in Excel. First
let me show you the script:
#!/usr/bin/perl
use strict;
use Spreadsheet::XLSX;
use SpreadSheet::WriteExcel;
my $excel = Spreadsheet::XLSX -> new ('build.xlsx');
my $sheet = $excel->Worksheet('Sheet1');
my ($row_min,$
I am using Spreadsheet::WriteExcel to create a spreadsheet with two columns in
it. It works. I have one final little problem.
here's the code
#!/usr/bin/perl
use strict;
use Spreadsheet::XLSX;
use SpreadSheet::WriteExcel;
my $excel = Spreadsheet::XLSX -> new ('build.xlsx');
my $sheet = $excel->
I am trying to write a script that pulls some data out of certain columns in a
spreadsheet and loads them into an array for comparing and updating. I am
having trouble actually seeing the data, it keeps giving me a HASH message. the
code is this:
@{$sheet->{Cells}$row};
my @indexes = (2 .. (2+
I am writing a script to pull data from a spreadsheet and use it in an array.
the code looks like this:
@{$sheet->{Cells}[$row]};
my @indexes = (2 .. (2+4-1));
my @dcells = @{$sheet->{Cells}[$row]}[@indexes];
open FILE, ">>feckyou.txt";
710)Spreadsheet::ParseExcel::Cell=HASH(0x70be758)
how do I access the actual data in the cell as opposed to this stuff?
Thanks
Ken
On Thursday, May 24, 2012 8:41:36 AM UTC-7, Ken Furff wrote:
> I am using the spreadsheet::xlsx module in a script im writing. I need to
> extract about 4 colum
I am using this code to try to access certain columns in a spreadsheet to load
into an array for comparison
@{$sheet->{Cells}[$row]};
my @indexes = (2 .. (2+4-1));
my @dcells = @{$sheet->{Cells}[$row]
I am using the spreadsheet::xlsx module in a script im writing. I need to
extract about 4 columns out of about 60. I need those specific columns for
comparison and updating. I assume that I'll load the data into an array or an
array of arrays for comparison. I am able to extract the contents of
