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()); }