Home
last modified time | relevance | path

Searched refs:worksheet1 (Results 1 – 25 of 177) sorted by relevance

12345678

/dports/textproc/py-xlsxwriter/XlsxWriter-1.4.3/examples/
H A Dsparklines2.py20 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 Doutline.py55 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 Dsparklines2.pl28 $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 Doutline.pl113 $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 Dstats_ext.pl22 $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 Doutline_collapsed.pl83 $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 Dcolors.pl49 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 Dtest_outline06.c26 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 Dtest_outline01.c23 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 Dtest_defined_name01.c15 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 Dtest_hyperlink04.c15 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 Doutline.pl110 $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 Dstats_ext.pl22 $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 Dcolors.pl48 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 Doutline_collapsed.pl82 $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 Doutline06.t68 $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 Doutline01.t66 $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 Dstats_ext.pl25 $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 Dcolors.pl50 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 Doutline.c43 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 Danatomy.c16 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 D22_mso_drawing_group.t25 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 Danalysis_to_excel.php63 $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 Danalysis_to_excel.php63 $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 Danalysis_to_excel.php63 $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 …]

12345678