我在后台用<SCRIPT LANGUAGE=\"VBScript\">
javalist += " set excelobj=createobject(\"excel.application\") \r\n ";
javalist += " excelobj.visible=true \r\n";
javalist += " set wk = excelobj.Workbooks.add \r\n ";
javalist += " set excelsheet =wk.Worksheets(\"sheet1\")\r\n "; javalist += " excelsheet.Columns(\"a:a\").ColumnWidth = 12 \r\n ";
javalist += " excelsheet.Columns(\"b:b\").ColumnWidth = 15 \r\n ";
javalist += " excelsheet.Columns(\"c:c\").ColumnWidth = 30 \r\n ";
javalist += " excelsheet.Columns(\"d:d\").ColumnWidth = 25 \r\n ";
javalist += " excelsheet.Columns(\"e:e\").ColumnWidth = 40 \r\n ";
javalist += " excelsheet.Columns(\"f:f\").ColumnWidth = 40 \r\n ";
javalist += " excelsheet.Columns(\"g:g\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"h:h\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"i:i\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"j:j\").ColumnWidth = 10 \r\n "; //表头
//第1列
javalist += " excelsheet.cells(1,1).HorizontalAlignment =3 \r\n";
javalist += " excelsheet.cells(1,1).VerticalAlignment = 2 \r\n";
javalist += " excelsheet.cells(1,1).value=\"编号\" \r\n";
javalist += " excelsheet.cells(1,1).Borders.LineStyle=1 \r\n";
string fileNumberStr = "aaa;bbb;ccc0"
javalist += " excelsheet.cells(" + y + ",1).value=\"" + fileNumberStr + "\" \r\n ";
javalist += " excelsheet.cells(" + y + ",1).Borders.LineStyle=1 \r\n ";
打印生成excel表格时怎么在 aaa;加换行,bbb;加换行??????
javalist += " set excelobj=createobject(\"excel.application\") \r\n ";
javalist += " excelobj.visible=true \r\n";
javalist += " set wk = excelobj.Workbooks.add \r\n ";
javalist += " set excelsheet =wk.Worksheets(\"sheet1\")\r\n "; javalist += " excelsheet.Columns(\"a:a\").ColumnWidth = 12 \r\n ";
javalist += " excelsheet.Columns(\"b:b\").ColumnWidth = 15 \r\n ";
javalist += " excelsheet.Columns(\"c:c\").ColumnWidth = 30 \r\n ";
javalist += " excelsheet.Columns(\"d:d\").ColumnWidth = 25 \r\n ";
javalist += " excelsheet.Columns(\"e:e\").ColumnWidth = 40 \r\n ";
javalist += " excelsheet.Columns(\"f:f\").ColumnWidth = 40 \r\n ";
javalist += " excelsheet.Columns(\"g:g\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"h:h\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"i:i\").ColumnWidth = 10 \r\n ";
javalist += " excelsheet.Columns(\"j:j\").ColumnWidth = 10 \r\n "; //表头
//第1列
javalist += " excelsheet.cells(1,1).HorizontalAlignment =3 \r\n";
javalist += " excelsheet.cells(1,1).VerticalAlignment = 2 \r\n";
javalist += " excelsheet.cells(1,1).value=\"编号\" \r\n";
javalist += " excelsheet.cells(1,1).Borders.LineStyle=1 \r\n";
string fileNumberStr = "aaa;bbb;ccc0"
javalist += " excelsheet.cells(" + y + ",1).value=\"" + fileNumberStr + "\" \r\n ";
javalist += " excelsheet.cells(" + y + ",1).Borders.LineStyle=1 \r\n ";
打印生成excel表格时怎么在 aaa;加换行,bbb;加换行??????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货