npoi
npoi copied to clipboard
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
When using NPOI to create a row with a complex header in word, it cannot be created correctly
Currently I haven't been able to find a way to create any graphs other than Line, Scatter, or Bar charts. Are there any plans for adding functionality for additional kinds...
Hi Team, Thanks for the great work that you are doing. I tried to convert **XLSX** To **HTML**, but it does not work. Seems to be only available for **XLS**....
在Excel中,LOOKUP(1,0/(A7=A1:A4),B1:B4)这个公式运行没有问题,而NPOI却输出#VALUE! 。望作者指点下,万分感谢! 环境:.NET Framework 4.52,NPOI版本:2.5.2(试过降级到其他版本,情况一样) ![Snipaste_2021-01-18_22-26-54](https://user-images.githubusercontent.com/76980743/104932454-9dcef880-59e2-11eb-9507-527e12ec3923.jpg) ![Snipaste_2021-01-18_22-33-35](https://user-images.githubusercontent.com/76980743/104932476-a293ac80-59e2-11eb-87d8-2781c5763e81.jpg)
In order to support the new [dynamic arrays](https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531) in Excel 365, NPOI would need to provide some sort of equivalents for these Range properties: Formula2 Formula2R1C1 HasSpill SpillParent SpilingToRange SavedAsArray...
My English is very bad, so I use google translation, if the description is not clear, please forgive me> If directly new HSSFWorkbook(),WriteProtectWorkbook is not workig,The reason is as follows....
Now, I am working on a project that automation fill-in JSON data on Excel template files. When creating a new Excel file from XSSFWorkbook, the address inside Shape has been...
以下代码在.net framework中可顺利执行,但在core 3.1下2.5.4版本报错:Illegal IndexedColor index: 0; ` /// /// (NPOI)Excel转HTML /// /// HTML文件的的名称(不带后缀) /// 需要转换Excel的绝对路径 /// public string ExcelToHtml(string Filename) { IWorkbook workbook; //获取后缀名称 string fileExt = Path.GetExtension(Filename).ToLower(); //判断是否可以打开该文件,如果出错则文件已经打开或者有异常 try...
I tried using `NPOI.HSSF.UserModel.AddColor` to add a custom color like so: ```c# public static short GetOrCreateColorIndex(this HSSFWorkbook workbook, Color color) { var palette = workbook.GetCustomPalette(); var xlsColor = palette.FindColor(color.R, color.G,...