public static Workbook Open(string path, xlUpdateLinks update_links = xlUpdateLinks.Never, bool read_only = false, string password = null)
{
XlCall.Excel(XlCall.xlcOpen, path, (int)update_links, read_only, Type.Missing, password, Type.Missing, true, 2,
Type.Missing, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Workbook wb = new Workbook(path);
return wb;
}
public Worksheet(string sheetRef)
{
int pos = sheetRef.IndexOf(']');
_workbook = new Workbook(sheetRef.Substring(1, pos - 1));
_sheetname = sheetRef.Substring(pos + 1, sheetRef.Length - pos - 1);
}
public Worksheet(Workbook wb, string sheet)
{
_workbook = wb;
_sheetname = sheet;
}