Python Forum
Strange Problem when reading from excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Strange Problem when reading from excel
#1
Hi everybody

I faced one strange problem:

I have two similar excel file and I am trying to read some data from them, For the first excel file is OK and when I run the code I receive the value in a millisecond , but for the second one it takes 2-3 min to get the results. (I just change the name of file in my code)

- The excel files are exactly similar (Actually I copied the second file from first and just changed the data!)
- Both of them has number format with same digits.
- Both files are in a same location

I do not know why the problem occurs.
Does anybody has any idea???

Thanks
Reply
#2
Without code, it's guessing.

Which framework do you use? pandas, pyexcel or others
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply
#3
It is a python module in a CAE software. I am reading with utils.XlsxOpen and utils.XlsxGetCellValue codes.
It is OK and I have the results, I checked with a new Excel file also and it is OK, but for an Excel file it takes too much to have the results.
Reply
#4
Hm, maybe you're using the wrong technique to access the data or you find a bug.
Can you debug the Python code in your CAE software?

If nothing helps, you may install an additional python package to handle the data with this packages instead of the API of your CAE software.
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  trouble reading string/module from excel as a list popular_dog 0 386 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,048 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Excel file reading problem max70990 1 866 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 6,863 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Loop reading csv file problem faustineaiden 1 1,539 Dec-11-2021, 08:40 AM
Last Post: ibreeden
  Strange problem related to "python service" Pavel_47 1 1,389 Dec-07-2021, 12:52 PM
Last Post: Pavel_47
  Problem in saving .xlsm (excel) file using pandas dataframe in python shantanu97 2 4,164 Aug-29-2021, 12:39 PM
Last Post: snippsat
  Reading from Excel: value not formula! faryad13 0 2,319 Oct-28-2020, 09:52 PM
Last Post: faryad13
  Reading SQL scripts from excel file and run it using python saravanatn 2 2,460 Aug-23-2020, 04:49 PM
Last Post: saravanatn
  Reading integers from a file; the problem may be the newline characters JRWoodwardMSW 2 1,921 Jul-14-2020, 02:27 AM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020