Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
2 Excel Spreadsheets into one
I may be driving myself crazy with this. I can't seem to make anything work. My goal is to combine about 20 or so spreadsheets into one monthly report. Each daily report only has a few items but the combined report will end up with over 50 sheets and numerous rows. I am just learning perl and I... -
2 Excel Spreadsheets into one
Referencing my other post, I can now read in multiple files but I cannot figure out how to write to a page that already exists. I get an error message when I try to write to a worksheet that I created earlier. i create sheet 1 from file 1 i create sheet 2 from file 2 i want to add to sheet 1... -
How do I combine 2 Excel Spreadsheets into one with perl?
Let me add to this and show where I am coming from : for(my $iSheet=0; $iSheet < $resource->{SheetCount} ; $iSheet++) { $oWkS = $resource->{Worksheet}[$iSheet]; $temp[$iSheet]= $oWkS->{Name}; #get worksheet name $maxRow=$oWkS->{MaxRow}; if... -
How do I combine 2 Excel Spreadsheets into one with perl?
I am trying to combine daily reports into one monthly report. my $workbook= Spreadsheet::WriteExcel->new("Integrated_source_list_$today.xls"); my $resource = Spreadsheet::ParseExcel::Workbook->Parse('resources.xls'); The way I have my program now it will read from one spreadsheet and write... -
comparing two sub_queries
I need to return the rows that are NOT duplicated. I am trying to be sure information on one db is the same on another db. I just need the odd rows returned. Is there an opposite of the union function? EX> Query 1 returns acct_num product_id count 1507692 100000500 1 1846486 106...
