You have some null values in excel. Add List.Clean to Remove and also Excel.Read is old method use Import Excel method.
Data_0 = DSOffice.Data.ImportExcel (ExcelFile,"SharedParameters", false, true); Data_1 = DSCore.List.RestOfItems(Data_0); Data_2 = DSCore.List.Transpose(Data_1); parameterName = Data_2; groupName = Data_2; type_ = Data_2; group = Data_2; instance = Data_2==true?true:false; categoryList = Elements.Category.ByName(Data_2);
Thanks a lot for the prompt reply!!! will do it and give you a feedback!
@Kulkul could you please tell me what am I missing here?
only use the Import Excel code, hook up a watch node. look at the results, how is your data coming in?
Troubleshoot this 1 step at a time, not a block of code at once. Analyze which step is not working as expected.
Try removing the “_” at the end of “Type”.
Use the import first to confirm you actually get data in Dynamo, the Transpose is failing because it has no data. Nobody can answer the question if you don’t do the steps to analyze the problem.
If I had to take a wild guess it is because your data in Excel is on a Tab that does not have the name SharedParameters.