How to read and append a .xlsm file in java

java file xlsm
Vandhana picture Vandhana · May 18, 2015 · Viewed 15.5k times · Source

I want to read and append a .xlsm file in java. I dont have any idea on how to do it. Do i need to download any jar file to work with it? All the search result provides a solution which uses apache poi(I did not get what it is). I dont use any IDE. Using simple FileReader and other logic can't I work with this type of file?

Please give me a clear idea on what is a .xlsm file and how to work with it using java.

Answer

Kenneth Clark picture Kenneth Clark · May 18, 2015

"XLSM is a Microsoft Excel macro-enabled spreadsheet that contains worksheets of cells arranged by rows and columns and embedded macros programmed in the Visual Basic for Applications language. XLSM files are like XLSX files, but with macros enabled. They can be opened with Excel 2007 or later, or by previous versions of Excel with Open XML component support."

You can read and write to the file using Apache poi.

Take a look at the following SO Posts

write to xlsm (Excel 2007) using apache poi

Read data from read only xlsm file using Java Apache POI

The Apache POI documentation is located at https://poi.apache.org/

Related questions

How do I create a Java string from the contents of a file?

I've been using the idiom below for some time now. And it seems to be the most wide-spread, at least on the sites I've visited. Is there a better/different way to read a file into a string in Java? …

Read More
How do I save a String to a text file using Java?

In Java, I have text from a text field in a String variable called "text". How can I save the contents of the "text" variable to a file?

Read More
How to read all files in a folder from Java?

How to read all the files in a folder through Java?

Read More