IronXL 支援 AWS Lambda Function 與 .NET Core
IronXL 完全支援 AWS Lambda Function 用於 .NET Standard Libraries、Core applications、.NET 5 和 .NET 6 專案。
要在 Visual Studio 中添加 AWS 工具包,請參照此連結 在 Visual Studio 的 AWS 工具包中使用 AWS Lambda 模板
將 AWS 工具包安裝到 Visual Studio 可以讓您建立 AWS Lambda Function 專案。您可以學習如何使用 Visual Studio 建立 AWS Lambda Function 專案,請參閱這個資料。 鏈接
工作中的 AWS Lambda 函數代碼範例
在創建新的 AWS Lambda 函數專案後,您可以嘗試此代碼段
namespace AWSLambdaIronXL
{
public class Function
{
/// <summary>
/// A simple function that takes a string and does a ToUpper
/// </summary>
/// <param name="input"></param>
/// <param name="context"></param>
/// <returns></returns>
public string FunctionHandler(string input, ILambdaContext context)
{
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLS);
var newSheet = workBook.CreateWorkSheet("new_sheet");
string ColumnsNames = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
foreach (char col in ColumnsNames)
{
for (int row = 1; row <= 50; row++)
{
var cellName = $"{col}{row}";
newSheet [cellName].Value = $"Cell : {cellName}";
}
}
return Convert.ToBase64String( workBook.ToByteArray());
}
}
}
namespace AWSLambdaIronXL
{
public class Function
{
/// <summary>
/// A simple function that takes a string and does a ToUpper
/// </summary>
/// <param name="input"></param>
/// <param name="context"></param>
/// <returns></returns>
public string FunctionHandler(string input, ILambdaContext context)
{
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLS);
var newSheet = workBook.CreateWorkSheet("new_sheet");
string ColumnsNames = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
foreach (char col in ColumnsNames)
{
for (int row = 1; row <= 50; row++)
{
var cellName = $"{col}{row}";
newSheet [cellName].Value = $"Cell : {cellName}";
}
}
return Convert.ToBase64String( workBook.ToByteArray());
}
}
}
Namespace AWSLambdaIronXL
Public Class [Function]
''' <summary>
''' A simple function that takes a string and does a ToUpper
''' </summary>
''' <param name="input"></param>
''' <param name="context"></param>
''' <returns></returns>
Public Function FunctionHandler(ByVal input As String, ByVal context As ILambdaContext) As String
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
Dim newSheet = workBook.CreateWorkSheet("new_sheet")
Dim ColumnsNames As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
For Each col As Char In ColumnsNames
For row As Integer = 1 To 50
Dim cellName = $"{col}{row}"
newSheet (cellName).Value = $"Cell : {cellName}"
Next row
Next col
Return Convert.ToBase64String(workBook.ToByteArray())
End Function
End Class
End Namespace
IronXL NuGet 套件可用於部署記錄於我們的 IronXL NuGet 安裝指南.