Skip to Content
avatar image
Former Member

Misalignement in Excel sheet,while downloading reports with huge data

Hi,

While downloading reports in excel with huge volume of data ,we are getting misalignments in the excel sheet(some data comes in wrong rows). Can you please suggest what could be the reason and how to correct it.

Regards,

Roopak

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 02, 2011 at 08:13 AM

    The maximum limitation of cells of excel is 65536 row,if your data exceeds it, you would need to download it to txt file first and upload it to Access,hope it helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Klaas,

      The no. of rows downloaded are 68740 and the mislalignment problem is in 10142th ,10143rd row.Kindly suggest.

      Thanks,

      Roopak

  • Feb 03, 2011 at 03:27 AM

    Hi,

    If you are using Office 2003, then you cannot download morethan 65000+. However if you use Office 2007, I think it gives you somewhere around 400000 records. (I didnt scroll below that!!!). Also the columns are morethan IV.

    However assuming that, even that version can have limitation, you can always download your data in a wordpad/notepad/textpad etc which are basically text editing tools. They dont have any such row or column restrictions.

    Once downloaded, you can randomly split them into some x number of files, based on the number of records and then open the same documents using xls sheet using tab value as delimiter. Now the alignment will be perfect in the excel sheet.

    Add comment
    10|10000 characters needed characters exceeded