• Aspose.Cells使用教程：Aspose.Cells使用場景介紹
• Aspose.Cells使用教程：創(chuàng)建你的第一個Aspose.Cells應(yīng)用

下面就是使用Aspose.Cells API創(chuàng)建Hello World應(yīng)用程序的步驟：

1. 創(chuàng)建一個Workbook類
2. 如果你有許可證，就盡情使用它；如果你正在使用一個評估版本，跳過許可證涉及到的代碼行
3. 創(chuàng)建一個新的Excel文件，或者打開一個現(xiàn)存的Excel文件
4. 在Excel文件中訪問任意的數(shù)據(jù)表中的單元格
5. 在訪問到的單元格中插入文字“Hello World! ”
6. 生成修改過后的Microsoft Excel文件

<Aspose.Cells最新版下載>

以上步驟的實現(xiàn)在下面的例子中的展示：

代碼示例：創(chuàng)建一個新的Workbook

下面的例子展示了從零開始創(chuàng)建一個新的Workbook，把 Hello World!寫入到第一個工作表的A1單元格，并保存為Excel文件。

輸出電子表格

C#

//Create a License object
License license = new License();

//Set the license of Aspose.Cells to avoid the evaluation
//limitations
license.SetLicense("Aspose.Cells.lic");

//Instantiate a Workbook object that represents Excel file.
Workbook wb = new Workbook();

//Note when you create a new workbook, a default worksheet
//"Sheet1" is added (by default) to the workbook.
//Access the first worksheet "Sheet1" in the book.
Worksheet sheet = wb.Worksheets[0];

//Access the "A1" cell in the sheet.
Cell cell = sheet.Cells["A1"];

//Input the "Hello World!" text into the "A1" cell
cell.PutValue("Hello World!");

//Save the Excel file.
wb.Save("d:\\MyBook.xls", SaveFormat.Excel97To2003);

VB.NET

'Create a License object
Dim license As License = New License()
'Set the license of Aspose.Cells to avoid the evaluation
'limitations
license.SetLicense("Aspose.Cells.lic")
'Instantiate a Workbook object that represents Excel file.
Dim wb As Workbook = New Workbook()
'Note when you create a new workbook, a default worksheet
'"Sheet1" is added (by default) to the workbook.
'Access the first worksheet "Sheet1" in the book.
Dim sheet As Worksheet = wb.Worksheets(0)
'Access the "A1" cell in the sheet.
Dim cell As Cell = sheet.Cells("A1")
'Input the "Hello World!" text into the "A1" cell
cell.PutValue("Hello World!")
'Save the Excel file.
wb.Save("d:\MyBook.xls", SaveFormat.Excel97To2003)

代碼示例：打開一個現(xiàn)有文件

下面的例子展示了打開一個名為“book.xls”的Microsoft Excel模板文件，并輸入“Hello World”文本到第一個工作表的A1單元格中，最后保存為workbook。

C#

//Create a License object
License license = new License();

//Set the license of Aspose.Cells to avoid the evaluation limitations
license.SetLicense("Aspose.Cells.lic");

//Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream("C:\\book1.xls", FileMode.Open);

//Instantiate a Workbook object that represents the existing Excel file
Workbook workbook = new Workbook(fstream);

//Get the reference of "A1" cell from the cells collection of a worksheet
Cell cell = workbook.Worksheets[0].Cells["A1"];

//Put the "Hello World!" text into the "A1" cell
cell.PutValue("Hello World!");

//Save the Excel file
workbook.Save("C:\\HelloWorld.xls");

//Closing the file stream to free all resources
fstream.Close();

VB.NET

'Create a License object
Dim license As License = New License()

'Set the license of Aspose.Cells to avoid the evaluation limitations
license.SetLicense("Aspose.Cells.lic")

'Creating a file stream containing the Excel file to be opened
Dim fstream As FileStream = New FileStream("C:\book1.xls", FileMode.Open)

'Instantiate a Workbook object that represents the existing Excel file
Dim workbook As Workbook = New Workbook(fstream)

'Get the reference of "A1" cell from the cells collection of a worksheet
Dim cell As Cell = workbook.Worksheets(0).Cells("A1")

'Put the "Hello World!" text into the "A1" cell
cell.PutValue("Hello World!")

'Save the Excel file
workbook.Save("C:\HelloWorld.xls")

'Closing the file stream to free all resources
fstream.Close()

購買最新正版授權(quán)！""

慧都年終盛典火爆開啟，一年僅一次的最強促銷，破冰鉅惠不容錯過！！優(yōu)惠詳情點擊查看>>