I am using Aspose.Cells v2.0.50727 [7.3.4.0]
Hi,
Hello Shakeel, Many thanks for responding.
Hi,
Thank You! Attached is a sample.
Hi,
//Find your last maximum cell and check if it is null, then add empty string inside it
Worksheet sh = workbookDesigner.Workbook.Worksheets[0];
Range r = sh.Cells.MaxDisplayRange;
Cell c = sh.Cells[r.RowCount-1, r.ColumnCount-1];
if (c.StringValue == “”)
c.PutValue("");
#endregion
using System.Linq;
using System.Text;
using Aspose.Cells;
using System.Data;
namespace TestCSV
{
class Program
{
static void Main(string[] args)
{
String templatePath = “…\…\Test.xlsx”;
WorkbookDesigner workbookDesigner = new WorkbookDesigner();
//Open a designer spreadsheet containing smart markers
workbookDesigner.Workbook = new Workbook(templatePath);
workbookDesigner.SetDataSource(GetTestData());
workbookDesigner.Process();
</font><font color="#0000ff">#region CELLSTEAM</font><font color="#800080">
//Find your last maximum cell and check if it is null, then add empty string inside it
Worksheet sh = workbookDesigner.Workbook.Worksheets[0];
Range r = sh.Cells.MaxDisplayRange;
Cell c = sh.Cells[r.RowCount-1, r.ColumnCount-1];
if (c.StringValue == "")
c.PutValue("");
#endregion
TxtSaveOptions opts = new TxtSaveOptions();
opts.Separator = ',';
workbookDesigner.Workbook.Save("cellsteam.csv", opts);
}
private static DataSet GetTestData()
{
DataSet ds = new DataSet();
DataTable ordersTable = ds.Tables.Add("TestData");
ordersTable.Columns.Add("Head1", typeof(string));
ordersTable.Columns.Add("Head2", typeof(string));
ordersTable.Columns.Add("Head3", typeof(string));
ordersTable.Columns.Add("Head4", typeof(string));
DataRow dr1 = ds.Tables["TestData"].NewRow();
dr1["Head1"] = "1";
//dr1["Head2"] = "";
dr1["Head3"] = "ABC";
//dr1["Head4"] = "";
ds.Tables["TestData"].Rows.Add(dr1);
DataRow dr2 = ds.Tables["TestData"].NewRow();
dr2["Head1"] = "1";
dr2["Head2"] = "1233";
dr2["Head3"] = "ABF";
dr2["Head4"] = "D";
ds.Tables["TestData"].Rows.Add(dr2);
DataRow dr3 = ds.Tables["TestData"].NewRow();
dr3["Head1"] = "1";
dr3["Head2"] = "4566";
dr3["Head3"] = "OJKY";
dr3["Head4"] = "B";
ds.Tables["TestData"].Rows.Add(dr3);
DataRow dr4 = ds.Tables["TestData"].NewRow();
dr4["Head1"] = "1";
dr4["Head2"] = "8799";
dr4["Head3"] = "TYFX";
//dr4["Head4"] = "";
ds.Tables["TestData"].Rows.Add(dr4);
return(ds);
}
}
}