C 操作excel实例

atedwithSpire.PDFfor.NET.\r`a()=\roST=\r(Excel.Worksheet)oWB.Sheets.get_Item(1);\roST.NameE”@zON”=\roST.get_Range(oST.Cells[l,1],oST.Cells[l,\r9]).MergeCells=true;\roST.Cells[l,1]E”@zON\na”;\roST.Cells[2,1]E”@z”=\roST.Cells[3,1]E“)*‡@”=\roST.Cells[4,1]E”/0‡@”;\roST.Cells[5,1]=”+,‡@”;\roST.Cells[6,1]E"23‡@”;\rfor(inti=1;i<=6;i++)\r(\roST.Cells[2,i+1]=nj[i-1]+"ON";\r}\roST.Cells[2,8]=”MON”=\roST.Cells[2,9]="q¡”;\roST.get_Range(oST.Cells[2,1],oST.Cells[6,\r9]).Borders.LineStyle=1;"aTe}\rŠ(6,9);\r}EvaluationWarning:ThedocumentwascreatedwithSpire.PDFfor.NET.\rprivatevoid¨©\rToolStripMenuItem_Click_l(objectsender,EventArgse)\r(\r`a()=\rdaÕ=\roST\r(Excel.Worksheet)oWB.Sheets.get_Item(1);\roST.NameE",ªz”=\r¨©a(“,ªz)\roST\r(Excel.Worksheet)oWB.Sheets.get_Item(2);\roST.Name="7‡”;\r¨©a(”7‡)\r}\r}\r)