Hi,
I want to read one designer using lightcells API and get values from database and fill the values into designer workbook.
I want read and write value in excel with Lightcells API to reduce the memory usage.
I have attached the data file and designer with this Post.
I used like this only for read and write in designer
Workbook data = new Workbook(myDir + “Data.xlsx”);
Cells cells = data.Worksheets[0].Cells;
//Export data to DataTable
DataTable table = data.Worksheets[0].Cells.ExportDataTable(0, 0, cells.MaxDataRow +1 , cells.MaxDataColumn +1, true);
//Rename the DataTable name to match the Smart Markers
table.TableName = “source”;
//Create WorkbookDesigner object
WorkbookDesigner designer = new WorkbookDesigner();
//Open the template file (which contains Smart Markers)
designer.Workbook = new Workbook(myDir + “designer.xlsx”);
//Set the DataTable as the data source
designer.SetDataSource(table);
//Process the Smart Markers to fill the data into the worksheet
designer.Process(true);
//Calculate all formulas
designer.Workbook.CalculateFormula();
//Save the result
designer.Workbook.Save(myDir + “output.xlsx”, SaveFormat.Xlsx);
Tell how to change this in Lightcells API. I check your sample. Please help me in this process
Best Regards,
Jaganlal.R.M