|
//Step
1 : Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine();
//Step 2 : Instantiate the excel
application object.
IApplication application = excelEngine.Excel;
string
fileName = Server.MapPath("App_data/BussinessObject.xlsx");
IWorkbook workbook =
application.Workbooks.Open(fileName,
ExcelOpenType.Automatic);
//IWorkbook workbook =
application.Workbooks.Create(1);
IWorksheet sheet = workbook.Worksheets[0];
string
text = sheet.GetAllText();
workbook.Version = ExcelVersion.Excel2010;
workbook.SaveAs("Output.xlsx", ExcelSaveType.SaveAsXLS, Response,
ExcelDownloadType.PromptDialog);
workbook.Close();
excelEngine.Dispose();
//**************************Work
Around**************************
public static class Extension
{
public static string GetAllText(this IWorksheet sheet)
{
int lastRow = sheet.UsedRange.LastRow;
int lastColumn = sheet.UsedRange.LastColumn;
StringBuilder builder = new StringBuilder();
IMigrantRange range = sheet.MigrantRange;
for (int iRow = 1; iRow <= lastRow; iRow++)
{
for (int iColumn = 1; iColumn <= lastColumn; iColumn++)
{
range.ResetRowColumn(iRow, iColumn);
builder.Append(range.DisplayText);
builder.Append(" ");
}
}
return builder.ToString();
}
}
//**************************Work
Around**************************
|
