Skip to main content
anusuyak349977
anusuyak349977
July 1, 2025
Solved

ReadExcelSheet Plugin - How to read the hidden columns?

  • July 1, 2025
  • 10 replies
  • 0 views

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8],

I am using Export Data Store Entity to Excel smart service to get the document and stored it in Appian.
In this, I have marked one of the column's visibility as false.

Now, when I try to read the excel sheet using readexcelsheet(), It's not giving me the hidden columns.

Anyother way to hide the columns in document but retrieve it in readexcelsheet()

    Best answer by anusuyak349977

    Solution:

    Uploaded the Sample Template document with the column as hidden.

    In the Process, created a copy of the Template document using Copy Document Plugin and then updated the new document with the data using Export Data Store Entity to Excel.

    10 replies

    harshas2775
    harshas2775
    July 1, 2025

    Try readexcelsheetpaging(). It returns hidden columns also. 
    Also, can you confirm if the excel generated has that hidden column? If excel wont have the column no function can get the respective data.

    anusuyak349977
    anusuyak349977Author
    July 1, 2025

    Excel Doxument is generated using Export Data Store Entity to Excel. In this, under selection, the column is mentioned with visibility as false. Does this count as hidden column?

    harshas2775
    harshas2775
    July 1, 2025

    I have not tried this scenario myself. Can you open the generated excel and tell here if you see the column in excel or not

    anusuyak349977
    anusuyak349977AuthorAnswer
    July 1, 2025

    Solution:

    Uploaded the Sample Template document with the column as hidden.

    In the Process, created a copy of the Template document using Copy Document Plugin and then updated the new document with the data using Export Data Store Entity to Excel.

      Terms & ConditionsAccessibility statement