public static XlsInput Load(string xlsFilePath)
{
if (!File.Exists(xlsFilePath))
{
throw new FileNotFoundException();
}
List <XlsWorksheetInfo> worksheets = new();
XlsUtil.WithWorkbook(xlsFilePath, workbook => {
var sheets = workbook.ReadWorksheetNames();
var numSheets = sheets.Count;
if (numSheets == 0)
{
throw new Exception("This workbook does not contain any sheets.");
}
for (var i = 0; i < numSheets; i++)
{
worksheets.Add(XlsWorksheetInfo.Load(workbook, i));
}
});
return(new() {
FilePath = xlsFilePath,
Worksheets = worksheets
});
}
private void Import()
{
XlsUtil.WithWorkbook(_filePath, workbook => {
var sheet = workbook.GetSheetAt(GetSheetIndex(workbook));
var rows = XlsUtil.ReadSheet(sheet, _firstRowIndex, _lastRowIndex, _firstColumnIndex, _lastColumnIndex);
SqlUtil.Import(
srcColNames: XlsUtil.ReadColumnNames(rows, _headerRow),
dataRows: rows.Skip(_headerRow ? 1 : 0),
importTable: _stmt.ImportTable,
temporaryTable: _temporaryTable,
truncateExistingTable: _truncateExistingTable,
ifConversionFails: _ifConversionFails,
notebook: _notebook,
runner: _runner,
env: _env);
});
}
private void Import()
{
XlsUtil.WithWorkbook(_filePath, workbook => {
workbook.SeekToWorksheet(GetSheetIndex(workbook));
var rows = workbook.ReadSheet(_firstRowIndex, _lastRowIndex, _firstColumnIndex, _lastColumnIndex);
SqlUtil.Import(
srcColNames: XlsUtil.ReadColumnNames(rows, _headerRow),
dataRows: rows.Skip(_headerRow ? 1 : 0),
importTable: _stmt.ImportTable,
temporaryTable: _temporaryTable,
truncateExistingTable: _truncateExistingTable,
stopAtFirstBlankRow: _stopAtFirstBlankRow,
ifConversionFails: _ifConversionFails,
blankValuesMethod: _blankValuesMethod,
notebook: _notebook,
runner: _runner,
env: _env);
});
}