Read all sheets from an XLS file in a loop

#1

This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Names node in a loop.


This is a companion discussion topic for the original entry at https://hub.knime.com/knime/workflows/Examples/01_Data_Access/01_Common_Type_Files/05_Read_all_sheets_from_an_XLS_file_in_a_loop*a2XQGQ7J9u0N6IZt
0 Likes

#2

Hello,

When i use large excel file, am facing the issue like ‘GC overhead limit exceed’, could you please give solution?

0 Likes

#3

Hi @baljicbe,

you could try to increase the amount of memory Java is allowed to use. To do so, you need to increase the Xmx value in the knime.ini. See here (under How can I increase the Java Heap Space for KNIME?) for instructions.

Cheers,
David

0 Likes

#4

Thanks

0 Likes

#5

Hello,

am using R script in R Source(Table), when i execute it shows the following error
importBufferedDataTable(): Supporting only ‘data.frame’, ‘data.table’, ‘matrix’ and ‘list’ for type of “knime.out” (was ‘tbl_df’).

any solution?

regards
Balaji G

0 Likes

#6

Hi @baljicbe,

unfortunately I’m not very ‘fluent’ in R, however that error indicates that the object you’re assigning to knime_out hast the wrong type. Could you check the type and make sure it is one of the types mentioned in the error message?
If that doesn’t solve the problem, could you maybe upload a workflow showing the error?

Cheers,
David

0 Likes

#7

Hi

Thanks, i got the answer from other peer

0 Likes