aardio调用c#编写的CarlosAg.ExcelXmlWriter.dll处理excel文件
By
笑口常
at 2021-07-17 • 0人收藏 • 1622人看过
主要是为了学习aardio调用c#的dll的方法.
该示例用到的组件官方:http://www.carlosag.net/Tools/ExcelXmlWriter/
我这里只是简单的调用实验, 具体的使用还是参考官方示例.
//调用C#程序集
import dotNet;
var appDomain = dotNet.clr().createAppDomain();
//加载应用程序目录下的程序集
var Demodll = appDomain.loadFile("\res\CarlosAg.ExcelXmlWriter.dll");
//声明接口
var book = Demodll.new("CarlosAg.ExcelXmlWriter.Workbook")
var sheet = book.Worksheets.Add("Sample");
var row = sheet.Table.Rows.Add();
row.Cells.Add("Hello aardio World");
book.Save("demo/test.xls");
5 个回复 | 最后更新于 2021-07-20
设置单元格样式:
//设置单元格样式
var style = book.Styles.Add("HeaderStyle");
style.Font.FontName = "Tahoma";
style.Font.Size = 34;
style.Font.Bold = true;
style.Font.Color = "Red";
style.Interior.Color = "Blue";
style.Interior.Pattern = Demodll.getEnum("StyleInteriorPattern.DiagCross");
//单元格样式, 第一种方式
row.Cells.Add( Demodll.new("CarlosAg.ExcelXmlWriter.WorksheetCell","Header 1", "HeaderStyle") );
//单元格样式, 第二种方式
var cell = row.Cells.Add("Header 3");
cell.StyleID = "HeaderStyle";
登录后方可回帖
谢谢 jacenHe 老大 , 现在新版本直接运行上面的代码没问题了.
//调用C#程序集 import dotNet; var appDomain = dotNet.clr().createAppDomain(); //加载应用程序目录下的程序集 var Demodll = appDomain.loadFile("\res\CarlosAg.ExcelXmlWriter.dll"); //声明接口 var book = Demodll.new("CarlosAg.ExcelXmlWriter.Workbook") var sheet = book.Worksheets.Add("Sample"); var row = sheet.Table.Rows.Add(); row.Index = 3; row.Cells.Add("Data"); row.Cells.Add("Data 1"); row.Cells.Add("Data 2"); row.Cells.Add("Data 3"); // Generate 30 rows for (i=0; 30; 1) { row = sheet.Table.Rows.Add(); row.Cells.Add("Row " + i); row.Cells.Add( Demodll.new("CarlosAg.ExcelXmlWriter.WorksheetCell",tostring(math.random(0,1000)),2) ); } // Add a Hyperlink row = sheet.Table.Rows.Add(); cell = row.Cells.Add(); cell.Data.Text = "aardio官方网址,点击访问"; cell.HRef = "http://www.aarido.com"; // Add a Formula for the above 30 rows cell = row.Cells.Add(); cell.Formula = "=SUM(R[-30]C:R[-1]C)"; book.Save("demo/test.xls"); import process process("demo/test.xls")