I want to find out CurrentRegion of a given excel cell. Sample code is something below if i use Microsoft interop dll's.
Application _excelApp = new Application();
Microsoft.Office.Interop.Excel.Workbook wb = _excelApp.Workbooks.Open(@"D:\Test\Test.xlsx",
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Microsoft.Office.Interop.Excel.Worksheet ws = wb.Sheets[1];
Range current = ws.Cells.Range["B4"].CurrentRegion;
object[,] valueArray = (object[,])current.get_Value(XlRangeValueDataType.xlRangeValueDefault);
Iam using Aspose cells to achive the same thing. I will give first data cell value some thing like 'B4', based on that i want the current region of the cells. i don't want other data in the sheet.
How can i achieve the same using Aspose? Is there any alternative for gettting same result?
sample code:
AsposeExcel.Workbook workbook = new AsposeExcel.Workbook(docStream);
AsposeExcel.Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.Here i am not finding anything
For Aspose worksheet Cells i didn't see Range property as well.
Note: CurrentRegion is something like in Excel sheet select a cell value and press Shift + Ctrl + * that will select a particular region of data.