Thread Excel Datei einlesen und schreiben mit Umlauten
(8 answers)
Opened by Jürgen at 2013-10-21 17:52
Hallo Raubtier,
anbei der gewünschte Code: Code (perl): (dl
)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 use strict; use warnings; use Spreadsheet::XLSX; use Excel::Writer::XLSX; my $workbook = Spreadsheet::XLSX->new("mappe1.xlsx"); my $worksheet = $workbook->worksheet("Tabelle1"); my $cell = $worksheet->get_cell( 2, 1 ); print $cell->value()."\n"; print $cell->encoding()."\n"; my $fuer = $cell->value(); my $workbook_write = Excel::Writer::XLSX->new( "mappe2.xlsx" ); my $new_sheet = $workbook_write->add_worksheet( "Tabelle1" ); $new_sheet->write_string( 1, 1, $fuer); Grüße Jürgen Last edited: 2013-10-22 11:02:21 +0200 (CEST) |