public void TestHideUnHideFlags()
{
Assert.IsTrue(wbH.IsSheetHidden(0));
Assert.IsFalse(wbH.IsSheetHidden(1));
Assert.IsFalse(wbU.IsSheetHidden(0));
Assert.IsFalse(wbU.IsSheetHidden(1));
}
public void TestHide()
{
wbU.SetSheetHidden(0, true);
Assert.IsTrue(wbU.IsSheetHidden(0));
Assert.IsFalse(wbU.IsSheetHidden(1));
MemoryStream out1 = new MemoryStream();
wbU.Write(out1);
out1.Close();
HSSFWorkbook wb2 = new HSSFWorkbook(new MemoryStream(out1.ToArray()));
Assert.IsTrue(wb2.IsSheetHidden(0));
Assert.IsFalse(wb2.IsSheetHidden(1));
}
public async Task <ActionResult> AppendDataToDB()
{
IFormFile file = Request.Form.Files[0];
string folderName = "Upload";
string webRootPath = _hostingEnvironment.WebRootPath;
string newPath = Path.Combine(webRootPath, folderName);
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
if (file.Length > 0)
{
string sFileExtension = Path.GetExtension(file.FileName).ToLower();
ISheet sheet;
string fullPath = Path.Combine(newPath, file.FileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
stream.Position = 0;
if (sFileExtension == ".xls")
{
HSSFWorkbook hssfwb = new HSSFWorkbook(stream); //This will read the Excel 97-2000 formats
for (int i = 0; i < hssfwb.NumberOfSheets; i++)
{
if (!(hssfwb.GetSheetAt(i) == null) && !hssfwb.IsSheetHidden(i))
{
sheet = hssfwb.GetSheetAt(i); //get first sheet from workbook
await ActivityAdd(sheet);
}
}
}
else
{
XSSFWorkbook hssfwb = new XSSFWorkbook(stream); //This will read 2007 Excel format
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
return(Ok());
}
}
return(BadRequest());
}
