Re: Generate Excel with macros

The easiest way would be to write a Macro in Excel, save the Excel workbook, open it on POI, add your data to the workbook, save it in POI. > Am 23.01.2020 um 07:50 schrieb useitforforum : > > Kindly somebody share the steps and ways to generate excel with macros. If > sample code is there, it

Re: Working with copy of Apache POI jenkins

You could create your own small application (eg convert excel to csv) and use Apache poi has a dependency that you include in your build file of your build tool (eg gradle). Then you use a Jenkins file to orchestrate the build tool (eg first step gradle clean and second step gradle build). This

Re: Extract Rich Text Field from excel

Can you provide a code snippet on how you get the RichtextString? Maybe also a link (not attachment) to a formatted Excel to reproduce the problem? It will facilitate troubleshooting significantly. > Am 08.10.2019 um 21:06 schrieb savan raiyani : > > Hi, > > I am trying to fetch Rich text data

Re: POI memory usage degradation

Which Java version did you use for 3.17 and 4.1.0. If you updated Java you may observe more memory consumption. Additionally, you can save memory and CPU if you read those files using SXSSF mode. Libraries on top of POI such as Excel Streamer may help you with this: https://github.com/monitorjbl

Re: JAVA 11 supported jar

Those look like snapshots. For production ready library you should use official releases and not snapshot libraries. You have to test yourself if they work for Java 11, but generally you should always stay with the latest version of Poi - also to avoid security issues. > Am 21.05.2019 um 11:58 s

Re: Using StAX parser for .xlsx files

thanks a lot to all comments. I updated the hadoopoffice library to include also Stax parsing. In a later stage I will also add reading comments. On Fri, May 18, 2018 at 11:37 PM Jörn Franke wrote: > Hi, > > I wonder if someone has already used successfully the StAX parser with >

Re: Reg :- Excel merge two different sheet

Do you have some code ? are these xlsx sheets? How many columns are filled? Are you doing formula evaluation? > Am 16.10.2018 um 07:19 schrieb Manivannan G : > > Hi Team, > > I am facing some problem while merging two different excel sheet data to one > excel sheet using XSSFWorkbook api using

Re: POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

Don't worry, I guess it was too late in the evening. I simply shade the dependency to commons-compress and everything seems to work (and I still can keep the POI integrated security mechanisms). Thanks btw. for 4.0.0 On Sat, Sep 29, 2018 at 11:54 PM Jörn Franke wrote: > Dear all, > &

POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

Dear all, as part of the HadoopOffice library ( https://github.com/zuinnote/hadoopoffice/wiki) we provide the functionality to read office documents, such as MS Excel, on Big Data platforms, such as Hadoop/Hive/Spark/Flink. I want to release a new version supporting POI 4.0.0, but I have one rema

Using StAX parser for .xlsx files

Hi, I wonder if someone has already used successfully the StAX parser with .xlsx files (ie instead of an event driven push model a pull model, cf. https://docs.oracle.com/javase/tutorial/jaxp/stax/why.html). Reason that I ask is that on Big Data platforms (for which we implemented the HadoopOffic