public static string SaveAndClose(ref ExcelWorker ex, string prefix) { string filename = prefix + "_" + DateTime.Now.ToShortDateString() + "_" + new Random().Next(100, 999).ToString(); string fileFullName = Environment.TlOutputPath + filename + ".xls"; ex.SaveAs(fileFullName); ex.Close(); return(fileFullName); }
static void Main(string[] args) { ExcelWorker test = new ExcelWorker("D:/table.xlsx"); try { test.Open(ReadOnly: false); int rows = test.Rows; int columns = test.Columns; //2:51 for (int i = 1; i <= 10; i++) { object[] str = test.ReadRow(i); } test.Close(); } catch (Exception e) { test.Close(); } }