tag:blogger.com,1999:blog-8712770457197348465.post3372986358729574170..comments2024-03-28T18:10:34.431-07:00Comments on Javarevisited: How to Read Write Excel file in Java - POI Examplejavin paulhttp://www.blogger.com/profile/15028902221295732276noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-8712770457197348465.post-12866663955611305422019-12-11T05:04:12.517-08:002019-12-11T05:04:12.517-08:00Can we search in xlsx excel file through Apache PO...Can we search in xlsx excel file through Apache POI?<br />If yes please tell me!!Anonymoushttps://www.blogger.com/profile/00813817097298703629noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-3962623353136965102019-11-25T22:24:05.813-08:002019-11-25T22:24:05.813-08:00@Balu regarding the "The file you are trying ...@Balu regarding the "The file you are trying to open, 'file.xls', is in a different format than specified by the file extension.", this happens when your ".xls" file is written in some different formant, for example it could be XLSX, HTML, TAB, etc.<br />You need to detect what format it is and read it accordingly, for example:<br /> - If it's XLSX then it will Mariohttps://www.blogger.com/profile/05197598595711807101noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-70484310040922407302019-11-19T19:55:20.642-08:002019-11-19T19:55:20.642-08:00Can we use HSSFCELL to read the data from XLSV fil...Can we use HSSFCELL to read the data from XLSV file, in above program you have used .Anonymoushttps://www.blogger.com/profile/14191539766004186382noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-30021466419010781992017-07-25T02:11:44.195-07:002017-07-25T02:11:44.195-07:00unable to save as the xlsx file by using the apach...unable to save as the xlsx file by using the apachi POI Objects and other java logic and please help on this that really great appreciation. Regards RamaAnonymoushttps://www.blogger.com/profile/01018251581660420812noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-2975481005779838792017-05-23T21:50:03.626-07:002017-05-23T21:50:03.626-07:00How to can i compare values values which are posit...How to can i compare values values which are positive and negative and are present in 200+ rows and if the difference between those numbers are zero, then it should give me "matched" as outputAnonymoushttps://www.blogger.com/profile/15498111704857605159noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-4676786133101800112017-04-10T21:30:18.279-07:002017-04-10T21:30:18.279-07:00Hi,
Is there a way to read and write into excel r...Hi, <br />Is there a way to read and write into excel real time. Eg. I pick an agency number from an excel, go a web page and extract some content and then need to paste that real-time into the excel in an adjacent cell and then iterate to the next agency id. Currently I am able to write the info into excel only once all info is extracted. Can this be done real time? Anonymoushttps://www.blogger.com/profile/17811356337932705592noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-55732468876756623902016-06-21T05:02:47.184-07:002016-06-21T05:02:47.184-07:00Paul, you are right. I have told the devopers the ...Paul, you are right. I have told the devopers the same. Thank you for the replyAnonymoushttps://www.blogger.com/profile/10493862375098736675noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-56405981468011782402016-06-21T04:56:46.685-07:002016-06-21T04:56:46.685-07:00@Balu, it seems blogger eats your error due to HTM...@Balu, it seems blogger eats your error due to HTML tags on it. Can you please post the error again after encoding HTML or XML tags e.g. < and >javin paulhttps://www.blogger.com/profile/15028902221295732276noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-20206118564464621182016-06-20T06:58:37.773-07:002016-06-20T06:58:37.773-07:00Hi, I am trying to read number of rows from xls fi...Hi, I am trying to read number of rows from xls file with jxl api. when i open the excel file manually, i get the below error <br /><br />The file you are trying to open, 'file.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?<br /><br /><br />Anonymoushttps://www.blogger.com/profile/10493862375098736675noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-33125525406242973452015-12-29T03:33:17.523-08:002015-12-29T03:33:17.523-08:00I get "cannot find symbol, symbol: method cre...I get "cannot find symbol, symbol: method createSheet(String)"Anonymoushttps://www.blogger.com/profile/04086487695711806190noreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-60871071363262468692015-12-15T23:27:17.522-08:002015-12-15T23:27:17.522-08:00Yes, you can open a password protected xlsx file i...Yes, you can open a password protected xlsx file in Java by using Apache POI API, it provides encryption decryption support out-of-box. You can further read and write content.<br /><br />You can use org.apache.poi.hssf.record.crypt to open password protected HSSF i.e. XLS file and org.apache.poi.poifs.crypt to open password protected XSSF or XLSX file.<br /><br />don't forget to provide Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-17822675214697319332015-12-15T23:25:54.160-08:002015-12-15T23:25:54.160-08:00Does POI allow you to open a password protected XL...Does POI allow you to open a password protected XLSX file in Java?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-32961076460473135482015-08-19T20:35:26.596-07:002015-08-19T20:35:26.596-07:00What is difference between reading or writing char...What is difference between reading or writing character data e.g. String over numberi data e.g. numbers and date and time? Do we need to do anything special to format date and numbers in a particular format? does Apache APOI provides support for such formatting?Anonymousnoreply@blogger.com