cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in uploading excel

Former Member
0 Kudos

Hi Experts,

I am facing problem while uploading the excel file.

The problem is while entering digits more than 12 in a cell its throwing file not found exception.

Please help me on this.

Regards,

Murali Krishnan N

Accepted Solutions (0)

Answers (2)

Answers (2)

Sharathmg
Active Contributor
0 Kudos

Murali Krishnan wrote:

Hi Experts,

I am facing problem while uploading the excel file.

The problem is while entering digits more than 12 in a cell its throwing file not found exception.

Please help me on this.

Regards,

Murali Krishnan N

If the problem is the value within the cell, then it may be an exception related to excel. Investigate or share the line at which the error occurs.

Regards,

Sharath

Former Member
0 Kudos

the problem is its not even getting the excel sheet if it has number with digits greater than 12

Sharathmg
Active Contributor
0 Kudos

When you say number with digits 12, is it in file name or inside excel?

Regards,

Sharath

Former Member
0 Kudos

inside excel i.e in excel cell

Sharathmg
Active Contributor
0 Kudos

So, you are able to read the excel and the point where excel cell is read(which holds digits greater than 12) then exception is raised, Right?

Regards,

Sharath

junwu
Active Contributor
0 Kudos

not right

Former Member
0 Kudos

before reading itself the exception is raised...

Sharathmg
Active Contributor
0 Kudos

hmm, but Murali, I find it strange that content inside excel results in an exception where file is not read.

Try to comment the code to read the contents of excel and test the code line by line.

Regards,

Sharath

Former Member
0 Kudos

Also its taking more time to upload if the number of rows in excel increases.

Qualiture
Active Contributor
0 Kudos

I have used xls uploads which had kilobytes of data in a single cell, so I'm sure your error is related to something else...

Can you post a little code snippet where you do the actual reading of the uploaded xls content?

Former Member
0 Kudos

Am uploading the excel in java server and reading it from there

the below code is for getting the excel cell content

HSSFCell cell = row.getCell();

Sharathmg
Active Contributor
0 Kudos

Then try to catch the exception which is raised HSSFCell/ getCell method. Then, read the exception text.

Regards,

Sharath

junwu
Active Contributor
0 Kudos

what java lib you using?

i think it has nothing to do with sap

Former Member
0 Kudos

am using POI jar

junwu
Active Contributor
0 Kudos

check if latest poi helps or not