/dports/textproc/py-xlsxwriter/XlsxWriter-1.4.3/examples/ |
H A D | sparklines2.py | 20 worksheet1.set_column('A:A', 14) 21 worksheet1.set_column('B:B', 50) 22 worksheet1.set_zoom(150) 35 worksheet1.write(row, 1, text) 46 worksheet1.write(row, 1, text) 57 worksheet1.write(row, 1, text) 68 worksheet1.write(row, 1, text) 80 worksheet1.write(row, 1, text) 92 worksheet1.write(row, 1, text) 103 worksheet1.write(row, 1, text) [all …]
|
H A D | outline.py | 55 worksheet1.write('A2', 'North') 56 worksheet1.write('A3', 'North') 57 worksheet1.write('A4', 'North') 62 worksheet1.write('B2', 1000) 63 worksheet1.write('B3', 1200) 64 worksheet1.write('B4', 900) 65 worksheet1.write('B5', 1200) 74 worksheet1.write('B7', 400) 75 worksheet1.write('B8', 600) 76 worksheet1.write('B9', 500) [all …]
|
/dports/textproc/p5-Excel-Writer-XLSX/Excel-Writer-XLSX-1.09/examples/ |
H A D | sparklines2.pl | 28 $worksheet1->set_zoom( 150 ); 39 $worksheet1->add_sparkline( 53 $worksheet1->add_sparkline( 68 $worksheet1->add_sparkline( 84 $worksheet1->add_sparkline( 99 $worksheet1->add_sparkline( 115 $worksheet1->add_sparkline( 131 $worksheet1->add_sparkline( 146 $worksheet1->add_sparkline( 162 $worksheet1->add_sparkline( [all …]
|
H A D | outline.pl | 113 $worksheet1->write( 'A2', 'North' ); 114 $worksheet1->write( 'A3', 'North' ); 115 $worksheet1->write( 'A4', 'North' ); 120 $worksheet1->write( 'B2', 1000 ); 121 $worksheet1->write( 'B3', 1200 ); 122 $worksheet1->write( 'B4', 900 ); 123 $worksheet1->write( 'B5', 1200 ); 132 $worksheet1->write( 'B7', 400 ); 133 $worksheet1->write( 'B8', 600 ); 134 $worksheet1->write( 'B9', 500 ); [all …]
|
H A D | stats_ext.pl | 22 $worksheet1->set_column( 'A:A', 20 ); 35 $worksheet1->write( 'A1', 'Count', $heading ); 36 $worksheet1->write( 'B1', '=COUNT(Data!B2:B9)' ); 38 $worksheet1->write( 'A2', 'Sum', $heading ); 39 $worksheet1->write( 'B2', '=SUM(Data!B2:B9)' ); 41 $worksheet1->write( 'A3', 'Average', $heading ); 44 $worksheet1->write( 'A4', 'Min', $heading ); 45 $worksheet1->write( 'B4', '=MIN(Data!B2:B9)' ); 47 $worksheet1->write( 'A5', 'Max', $heading ); 48 $worksheet1->write( 'B5', '=MAX(Data!B2:B9)' ); [all …]
|
H A D | outline_collapsed.pl | 83 $worksheet1->set_row( 1, undef, undef, 0, 2 ); 84 $worksheet1->set_row( 2, undef, undef, 0, 2 ); 85 $worksheet1->set_row( 3, undef, undef, 0, 2 ); 86 $worksheet1->set_row( 4, undef, undef, 0, 2 ); 87 $worksheet1->set_row( 5, undef, undef, 0, 1 ); 89 $worksheet1->set_row( 6, undef, undef, 0, 2 ); 90 $worksheet1->set_row( 7, undef, undef, 0, 2 ); 91 $worksheet1->set_row( 8, undef, undef, 0, 2 ); 92 $worksheet1->set_row( 9, undef, undef, 0, 2 ); 93 $worksheet1->set_row( 10, undef, undef, 0, 1 ); [all …]
|
H A D | colors.pl | 49 my $worksheet1 = $workbook->add_worksheet( 'Named colors' ); 51 $worksheet1->set_column( 0, 3, 15 ); 53 $worksheet1->write( 0, 0, "Index", $heading ); 54 $worksheet1->write( 0, 1, "Index", $heading ); 55 $worksheet1->write( 0, 2, "Name", $heading ); 56 $worksheet1->write( 0, 3, "Color", $heading ); 67 $worksheet1->write( $i + 1, 0, $index, $center ); 68 $worksheet1->write( $i + 1, 1, sprintf( "0x%02X", $index ), $center ); 69 $worksheet1->write( $i + 1, 2, $color, $center ); 70 $worksheet1->write( $i + 1, 3, '', $format );
|
/dports/math/libxlsxwriter/libxlsxwriter-RELEASE_1.1.4/test/functional/src/ |
H A D | test_outline06.c | 26 worksheet_set_column(worksheet1, COLS("A:A"), 20, NULL); in main() 40 worksheet_write_string(worksheet1, CELL("A1"), "Region", bold); in main() 47 worksheet_write_string(worksheet1, CELL("B1"), "Sales", bold); in main() 48 worksheet_write_number(worksheet1, CELL("B2"), 1000 , NULL); in main() 49 worksheet_write_number(worksheet1, CELL("B3"), 1200 , NULL); in main() 50 worksheet_write_number(worksheet1, CELL("B4"), 900 , NULL); in main() 51 worksheet_write_number(worksheet1, CELL("B5"), 1200 , NULL); in main() 60 worksheet_write_number(worksheet1, CELL("B7"), 400 , NULL); in main() 61 worksheet_write_number(worksheet1, CELL("B8"), 600 , NULL); in main() 62 worksheet_write_number(worksheet1, CELL("B9"), 500 , NULL); in main() [all …]
|
H A D | test_outline01.c | 23 worksheet_set_column(worksheet1, COLS("A:A"), 20, NULL); in main() 37 worksheet_write_string(worksheet1, CELL("A1"), "Region", bold); in main() 44 worksheet_write_string(worksheet1, CELL("B1"), "Sales", bold); in main() 45 worksheet_write_number(worksheet1, CELL("B2"), 1000 , NULL); in main() 46 worksheet_write_number(worksheet1, CELL("B3"), 1200 , NULL); in main() 47 worksheet_write_number(worksheet1, CELL("B4"), 900 , NULL); in main() 48 worksheet_write_number(worksheet1, CELL("B5"), 1200 , NULL); in main() 57 worksheet_write_number(worksheet1, CELL("B7"), 400 , NULL); in main() 58 worksheet_write_number(worksheet1, CELL("B8"), 600 , NULL); in main() 59 worksheet_write_number(worksheet1, CELL("B9"), 500 , NULL); in main() [all …]
|
H A D | test_defined_name01.c | 15 lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, NULL); in main() local 19 worksheet_set_paper(worksheet1, 9); in main() 20 worksheet1->vertical_dpi = 200; in main() 22 worksheet_print_area(worksheet1, RANGE("A1:E6")); in main() 23 worksheet_autofilter(worksheet1, RANGE("F1:G1")); in main() 24 worksheet_write_string(worksheet1, CELL("G1"), "Filter", NULL); in main() 25 worksheet_write_string(worksheet1, CELL("F1"), "Auto", NULL); in main() 26 worksheet_fit_to_pages(worksheet1, 2, 2); in main()
|
H A D | test_hyperlink04.c | 15 lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, NULL); in main() local 24 …worksheet_write_url_opt(worksheet1, CELL("A1"), "internal:Sheet2!A1", NULL, NULL, NU… in main() 25 …worksheet_write_url_opt(worksheet1, CELL("A3"), "internal:Sheet2!A1:A5", NULL, NULL, NU… in main() 26 …worksheet_write_url_opt(worksheet1, CELL("A5"), "internal:'Data Sheet'!D5", NULL, "Some text", NU… in main() 27 …worksheet_write_url_opt(worksheet1, CELL("E12"), "internal:Sheet1!J1", NULL, NULL, NU… in main() 28 …worksheet_write_url_opt(worksheet1, CELL("G17"), "internal:Sheet2!A1", NULL, "Some text", NU… in main() 29 …worksheet_write_url_opt(worksheet1, CELL("A18"), "internal:Sheet2!A1", NULL, NULL, "T… in main() 30 …worksheet_write_url_opt(worksheet1, CELL("A20"), "internal:Sheet2!A1", NULL, "More text", "T… in main()
|
/dports/textproc/p5-Spreadsheet-WriteExcel/Spreadsheet-WriteExcel-2.40/examples/ |
H A D | outline.pl | 110 $worksheet1->set_column('A:A', 20); 114 $worksheet1->write('A2', 'North'); 115 $worksheet1->write('A3', 'North'); 121 $worksheet1->write('B2', 1000); 122 $worksheet1->write('B3', 1200); 123 $worksheet1->write('B4', 900); 124 $worksheet1->write('B5', 1200); 133 $worksheet1->write('B7', 400); 134 $worksheet1->write('B8', 600); 135 $worksheet1->write('B9', 500); [all …]
|
H A D | stats_ext.pl | 22 $worksheet1->set_column('A:A', 20); 37 $worksheet1->write('A1', 'Count', $heading); 38 $worksheet1->write('B1', '=COUNT(Data!B2:B9)'); 40 $worksheet1->write('A2', 'Sum', $heading); 41 $worksheet1->write('B2', '=SUM(Data!B2:B9)'); 43 $worksheet1->write('A3', 'Average', $heading); 46 $worksheet1->write('A4', 'Min', $heading); 47 $worksheet1->write('B4', '=MIN(Data!B2:B9)'); 49 $worksheet1->write('A5', 'Max', $heading); 50 $worksheet1->write('B5', '=MAX(Data!B2:B9)'); [all …]
|
H A D | colors.pl | 48 my $worksheet1 = $workbook->add_worksheet('Named colors'); 50 $worksheet1->set_column(0, 3, 15); 52 $worksheet1->write(0, 0, "Index", $heading); 53 $worksheet1->write(0, 1, "Index", $heading); 54 $worksheet1->write(0, 2, "Name", $heading); 55 $worksheet1->write(0, 3, "Color", $heading); 66 $worksheet1->write($i+1, 0, $index, $center); 67 $worksheet1->write($i+1, 1, sprintf("0x%02X", $index), $center); 68 $worksheet1->write($i+1, 2, $color, $center); 69 $worksheet1->write($i+1, 3, '', $format);
|
H A D | outline_collapsed.pl | 82 $worksheet1->set_row(1, undef, undef, 0, 2); 83 $worksheet1->set_row(2, undef, undef, 0, 2); 84 $worksheet1->set_row(3, undef, undef, 0, 2); 85 $worksheet1->set_row(4, undef, undef, 0, 2); 86 $worksheet1->set_row(5, undef, undef, 0, 1); 88 $worksheet1->set_row(6, undef, undef, 0, 2); 89 $worksheet1->set_row(7, undef, undef, 0, 2); 90 $worksheet1->set_row(8, undef, undef, 0, 2); 91 $worksheet1->set_row(9, undef, undef, 0, 2); 92 $worksheet1->set_row(10, undef, undef, 0, 1); [all …]
|
/dports/textproc/p5-Excel-Writer-XLSX/Excel-Writer-XLSX-1.09/t/regression/ |
H A D | outline06.t | 68 $worksheet1->write( 'A2', 'North' ); 69 $worksheet1->write( 'A3', 'North' ); 70 $worksheet1->write( 'A4', 'North' ); 75 $worksheet1->write( 'B2', 1000 ); 76 $worksheet1->write( 'B3', 1200 ); 77 $worksheet1->write( 'B4', 900 ); 78 $worksheet1->write( 'B5', 1200 ); 87 $worksheet1->write( 'B7', 400 ); 88 $worksheet1->write( 'B8', 600 ); 89 $worksheet1->write( 'B9', 500 ); [all …]
|
H A D | outline01.t | 66 $worksheet1->write( 'A2', 'North' ); 67 $worksheet1->write( 'A3', 'North' ); 68 $worksheet1->write( 'A4', 'North' ); 73 $worksheet1->write( 'B2', 1000 ); 74 $worksheet1->write( 'B3', 1200 ); 75 $worksheet1->write( 'B4', 900 ); 76 $worksheet1->write( 'B5', 1200 ); 85 $worksheet1->write( 'B7', 400 ); 86 $worksheet1->write( 'B8', 600 ); 87 $worksheet1->write( 'B9', 500 ); [all …]
|
/dports/textproc/p5-Spreadsheet-WriteExcelXML/Spreadsheet-WriteExcelXML-0.15/examples/ |
H A D | stats_ext.pl | 25 $worksheet1->set_column('A:A', 20); 40 $worksheet1->write('A1', 'Count', $heading); 41 $worksheet1->write('B1', '=COUNT(Data!B2:B9)'); 43 $worksheet1->write('A2', 'Sum', $heading); 44 $worksheet1->write('B2', '=SUM(Data!B2:B9)'); 46 $worksheet1->write('A3', 'Average', $heading); 49 $worksheet1->write('A4', 'Min', $heading); 50 $worksheet1->write('B4', '=MIN(Data!B2:B9)'); 52 $worksheet1->write('A5', 'Max', $heading); 53 $worksheet1->write('B5', '=MAX(Data!B2:B9)'); [all …]
|
H A D | colors.pl | 50 my $worksheet1 = $workbook->add_worksheet('Named colors'); 52 $worksheet1->set_column(0, 3, 15); 54 $worksheet1->write(0, 0, "Index", $heading); 55 $worksheet1->write(0, 1, "Index", $heading); 56 $worksheet1->write(0, 2, "Name", $heading); 57 $worksheet1->write(0, 3, "Color", $heading); 68 $worksheet1->write($i+1, 0, $index, $center); 69 $worksheet1->write($i+1, 1, sprintf("0x%02X", $index), $center); 70 $worksheet1->write($i+1, 2, $color, $center); 71 $worksheet1->write($i+1, 3, '', $format);
|
/dports/math/libxlsxwriter/libxlsxwriter-RELEASE_1.1.4/examples/ |
H A D | outline.c | 43 worksheet_set_column(worksheet1, COLS("A:A"), 20, NULL); in main() 59 worksheet_write_string(worksheet1, CELL("A1"), "Region", bold); in main() 66 worksheet_write_string(worksheet1, CELL("B1"), "Sales", bold); in main() 67 worksheet_write_number(worksheet1, CELL("B2"), 1000, NULL); in main() 68 worksheet_write_number(worksheet1, CELL("B3"), 1200, NULL); in main() 69 worksheet_write_number(worksheet1, CELL("B4"), 900, NULL); in main() 70 worksheet_write_number(worksheet1, CELL("B5"), 1200, NULL); in main() 79 worksheet_write_number(worksheet1, CELL("B7"), 400, NULL); in main() 80 worksheet_write_number(worksheet1, CELL("B8"), 600, NULL); in main() 81 worksheet_write_number(worksheet1, CELL("B9"), 500, NULL); in main() [all …]
|
H A D | anatomy.c | 16 lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, "Demo"); in main() local 32 worksheet_set_column(worksheet1, 0, 0, 20, NULL); in main() 35 worksheet_write_string(worksheet1, 0, 0, "Peach", NULL); in main() 36 worksheet_write_string(worksheet1, 1, 0, "Plum", NULL); in main() 39 worksheet_write_string(worksheet1, 2, 0, "Pear", myformat1); in main() 42 worksheet_write_string(worksheet1, 3, 0, "Persimmon", myformat1); in main() 46 worksheet_write_number(worksheet1, 5, 0, 123, NULL); in main() 47 worksheet_write_number(worksheet1, 6, 0, 4567.555, myformat2); in main()
|
/dports/textproc/p5-Spreadsheet-WriteExcel/Spreadsheet-WriteExcel-2.40/t/ |
H A D | 22_mso_drawing_group.t | 25 my $worksheet1; 43 $worksheet1 = $workbook->add_worksheet(); 86 $worksheet1 = $workbook->add_worksheet(); 129 $worksheet1 = $workbook->add_worksheet(); 172 $worksheet1 = $workbook->add_worksheet(); 215 $worksheet1 = $workbook->add_worksheet(); 259 $worksheet1 = $workbook->add_worksheet(); 303 $worksheet1 = $workbook->add_worksheet(); 352 $worksheet1 = $workbook->add_worksheet(); 401 $worksheet1 = $workbook->add_worksheet(); [all …]
|
/dports/www/moodle310/moodle/mod/feedback/ |
H A D | analysis_to_excel.php | 63 $worksheet1 = $workbook->add_worksheet(); variable 65 $worksheet1->hide_gridlines(); 66 $worksheet1->set_column(0, 0, 10); 67 $worksheet1->set_column(1, 1, 30); 68 $worksheet1->set_column(2, 20, 15); 80 $worksheet1->write_string($rowoffset1, 0, userdate(time()), $xlsformats->head1); 87 $worksheet1->write_string($rowoffset1, 93 $worksheet1->write_string($rowoffset1, 100 $worksheet1->write_string($rowoffset1, 1, get_string('question', 'feedback'), $xlsformats->head1); 101 $worksheet1->write_string($rowoffset1, 2, get_string('responses', 'feedback'), $xlsformats->head1); [all …]
|
/dports/www/moodle311/moodle/mod/feedback/ |
H A D | analysis_to_excel.php | 63 $worksheet1 = $workbook->add_worksheet(); variable 65 $worksheet1->hide_gridlines(); 66 $worksheet1->set_column(0, 0, 10); 67 $worksheet1->set_column(1, 1, 30); 68 $worksheet1->set_column(2, 20, 15); 80 $worksheet1->write_string($rowoffset1, 0, userdate(time()), $xlsformats->head1); 87 $worksheet1->write_string($rowoffset1, 93 $worksheet1->write_string($rowoffset1, 100 $worksheet1->write_string($rowoffset1, 1, get_string('question', 'feedback'), $xlsformats->head1); 101 $worksheet1->write_string($rowoffset1, 2, get_string('responses', 'feedback'), $xlsformats->head1); [all …]
|
/dports/www/moodle39/moodle/mod/feedback/ |
H A D | analysis_to_excel.php | 63 $worksheet1 = $workbook->add_worksheet(); variable 65 $worksheet1->hide_gridlines(); 66 $worksheet1->set_column(0, 0, 10); 67 $worksheet1->set_column(1, 1, 30); 68 $worksheet1->set_column(2, 20, 15); 80 $worksheet1->write_string($rowoffset1, 0, userdate(time()), $xlsformats->head1); 87 $worksheet1->write_string($rowoffset1, 93 $worksheet1->write_string($rowoffset1, 100 $worksheet1->write_string($rowoffset1, 1, get_string('question', 'feedback'), $xlsformats->head1); 101 $worksheet1->write_string($rowoffset1, 2, get_string('responses', 'feedback'), $xlsformats->head1); [all …]
|