- Code: Select all
//worksheet.InsertDataTable(dataTable, columnHeaders, firstRow, firstColumn, transTypes);
worksheet.InsertDataTable(dataTable, true, 1, 1, true);
How can I make the InsertDataTable method set the format to number?
//worksheet.InsertDataTable(dataTable, columnHeaders, firstRow, firstColumn, transTypes);
worksheet.InsertDataTable(dataTable, true, 1, 1, true);
//code1
DataTable dt = new DataTable();
dt.Columns.Add("columns1", typeof(double));
dt.Columns.Add("columns2", Type.GetType("System.String"));
DataRow newRow = dt.NewRow();
newRow["columns1"] =88882.3232;
newRow["columns2"] = "ddddd";
dt.Rows.Add(newRow);
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.InsertDataTable(dt, true, 1, 1,true);
workbook.SaveToFile(@"..\..\Result.xlsx",ExcelVersion.Version2010);
//code2
sheet.Range["C4"].NumberFormat = "0.00";
static int n=2;
Workbook workbook = new Workbook();//Initialize a new Workboook object
public void button1_Click(object sender, EventArgs e)
{
try
{
button1.Text = Convert.ToString(n);//getting the count of click
workbook.LoadFromFile(@"C:\Program Files\Warehouse\Sample1.xls");
Worksheet sheet = workbook.Worksheets[0];//Get the first worksheet
sheet.Range["A" + n].Text = "Party Name";//Write string values in a cell
sheet.Range["B" + n].Text = "amount";
sheet.Range["C" + n].Text = "crain";
sheet.Range["D" + n].Text = "drain";
sheet.Range["E" + n].Text = "pain";
sheet.Range["F" + n].Text = "devel";
workbook.SaveToFile(@"C:\Program Files\Warehouse\Sample1.xls");
n++;
}
catch { }
}