2023年1月28日 星期六

[C#] 插入圖片到Excel

using Microsoft.Office.Interop.Excel;
Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Open("example.xlsx");
Worksheet worksheet = workbook.Worksheets[1];

Range range = worksheet.Range["A1"];//取得儲存格的長寬

Bitmap originalImage = new Bitmap(filePath);//取得圖片的長寬
int newWidth = originalImage.Width;
int newHeight = originalImage.Height;

worksheet.Shapes.AddPicture("image.jpg", Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, range.Left, range.Top, range.Width, range.Height);//(路徑,MSO,靠左座標,靠上座標,寬,高)

workbook.Save();
workbook.Close();
excelApp.Quit();

沒有留言:

張貼留言