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 Chriss Miller 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
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?
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...
