Hi Team,
Is it possible to get Excel (Macro Enabled) Queries and Connection.
Example :
Get All =>
a) connection from an Excel sheet
b) Queries from an Excel Sheet
Have a great day
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
//Traverse all worksheets
foreach (Worksheet worksheet in workbook.Worksheets)
{
for (int i = 0; i < worksheet.Rows.Length;i++)
{
for (int j = 0; j < worksheet.Rows[i].Columns.Length;j++)
{
CellRange cell = worksheet.Rows[i].Columns[j];
//Get cell content
string values = cell.Value;
}
}
}