Hi there,
we I use the following code to copy one of my worksheet I got exception "object no reference" I have attached the excel file. This is cirtical to our client. Thanks for your help.
Tony
public bool GetIndexTextReader(Stream inputDataStream, out TextReader indexTextReader)
{
if (inputDataStream != null && inputDataStream.Length > 0)
{
StreamReader reader = null;
MemoryStream ms = null;
try
{
AsposeLicenseHelper.VerifyLicense();
Workbook workbook = new Workbook(inputDataStream);
ms = new MemoryStream();
for (int i = 0; i < workbook.Worksheets.Count; i++)
{
if (workbook.Worksheets[i].IsVisible)
{
Workbook wbk = new Workbook();
wbk.Worksheets[0].Copy(workbook.Worksheets[i], );
wbk.Save(ms, SaveFormat.CSV);
}
}
reader = new StreamReader(ms, Encoding.Default);
reader.BaseStream.Seek(0, SeekOrigin.Begin);
indexTextReader = reader;
return true;
}
catch
{
if (ms != null)
ms.Close();
if (reader != null)
reader.Close();
}
}
indexTextReader = null;
return false;
}
}