Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Excel 2007 Node

Hybrid View

  1. #1
    New Contributor
    Join Date
    Oct 2009
    Location
    Atlanta
    Posts
    3

    Question Excel 2007 Node

    What is the status of a node that works with Excel 2007?

    The company I am working with produces thousands of files in Excel 2007 and it isn't feasible for me to manually convert XLSX files to CSV's.

  2. #2
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    This is one of the reasons the Excel File node is still in experimental, unfortunately. The library that we use to implement the Excel node currently does not support Excel 2007; however, it is being developed, and there is an alpha version, so progress is being made. I can't make a commitment as to when it will be released, but know that when it does, we will incorporate those updates to our product in the next maintenance release.

    Cheers
    Rich

  3. #3
    Lavastorm Employee
    Join Date
    Jun 2009
    Location
    UK
    Posts
    18

    Default

    It seems that there are some batch utilities available on the "world wide web" to convert from xlsx to xls, which may be useful here as a work around.


    Perhaps obvious, but DISCLAIMER: the purchase or use of third party utilities is entirely at own risk, etc. etc.......


    It is good to know the work on Excel 2007 is on-going. I'll look forward to this "xlsx" node being available!
    Last edited by henk01; 12-07-2009 at 12:58 PM.

  4. #4

    Default

    Quote Originally Posted by henk01 View Post
    It seems that there are some batch utilities available on the "world wide web" to convert from xlsx to xls, which may be useful here as a work around.


    Perhaps obvious, but DISCLAIMER: the purchase or use of third party utilities is entirely at own risk, etc. etc.......


    It is good to know the work on Excel 2007 is on-going. I'll look forward to this "xlsx" node being available!

    Guys, Any updates on a new node to import .xlsx files?

    thanks, Daniel

  5. #5
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    Guys, Any updates on a new node to import .xlsx files?

    thanks, Daniel
    A new fully supported (non-experimental) version of the Excel File node, will be part of LAE 4.5.2 - the next LAE maintenance release on the 4.5 branch. This will handle both .xlsx & .xls flies.

    This release is in the finals iterations of regression testing at the moment and should be available sometime before the end of the month.





    When the worksheet is read in, all columns are changed to unicode. It is possible to indicate the required type for each column? Say to read column 1 as integer, column 2 as double, column 3 as string, etc.
    Unfortunately, there will still be no mechanism for specifying the type on each column. As Rich mentioned, since Excel is cell-based, there is no guarantee that the cells within a column will all have the same format. This means that there is no way to auto-detect the column type. If the user where to specify the column type within the WorkbookSpec parameter, there would also need to be parameters governing what the node should do in case any of the cells within the column cannot be converted to the specified type. However, we will consider these enhancement for future releases.

    Regards,
    Tim.

  6. #6

    Default New Excel File node in LAE 4.5.2

    There's a new Excel File node in LAE 4.5.2 that supports .xlsx files (Excel 2007 and beyond).

    LAE 4.5.2 was released on 22-August-11.

  7. #7

    Default

    We are trying to use excel node but it does not import big excel files. It says "ERROR: Insufficient memory to read the Excel file(s)." There is 74000 record not more than that.

    Any idea or comment?

    Kind Regars,

  8. #8

    Default

    I haven't used the current experimental excel reader node and really need an example showing how to use the node to read an example spreadsheet. Given you seem to have done quite a bit of work with this node, I wondering whether you might have an example (not to complex) to share. Then I could use this as a template for my current task and later tasks.

    Thanks Brett

  9. #9
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Sure, post an example Excel file, and I will post the Excel node to read it.

    Cheers
    Rich

  10. #10

    Default Sample excel sheet

    Hi Rich,
    I attached the spreadsheet I need to read.

    Regards,

    Brett
    Last edited by rboccuzzi; 06-14-2010 at 01:28 PM.

Similar Threads

  1. Replies: 3
    Last Post: 12-23-2011, 12:51 PM
  2. Excel File Node FileName Output
    By Pooja in forum Data Acquisition
    Replies: 2
    Last Post: 08-22-2011, 12:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •