1 Reply Latest reply on Jul 2, 2010 12:00 AM by NL_Derek-56V59O

    Import Excel spreadsheet into RH table

    tnewland82

      I have a large Excel spreadsheet (sheet/workbook) that I need to import into an RH table. I have tried saving it as an HTML webpage and importing it, I have tried XML, and many other methods.

       

      When I tried importing as an HTML, the file would never appear in my Project Manager but would be in the project folder on my computer. Even if I tried to use the "Find Topic" feature, I could not locate the file in the Project Manager. (Background info-I exported the spreadsheet to HTML/Webpage file)

       

      When I tried to import an Word/Text file, the file did appear in the Project Manager-however, it was all a big "blob" of text-it did not have everything laid out into columns. (Background info-I exported the spreadsheet to a text file).

       

      When I tried to import an XML file, the file did not appear as a single file in the Project Manager. Instead, the file broke out into NUMEROUS files-one for every single line item in the spreadsheet (just under 1,000).

       

      Any help/suggestions?