How to read excel cell value in K2 five?

Good day kathija

Please see the following:

Excel and Exchange Mailbox Service Brokers: https://community.k2.com/t5/K2-Five/Excel-and-Exchange-Mailbox-Service-Brokers-K2-5/td-p/102967.

Best,

Sunrise

Hi, 

Thank you for the response,

I am using Excel import Service Broker in my application. This broker will  do bulk insertion of data  into SMO or SQL table. I dont need to insert the data into database. I just need to read few excel cell values from the imported excel. This values will be passed as input  to another function. Is there any Broker that will allow to read the Excel cell values?

Thank you

Good day   @kathija;

Please see this post:
https://community.k2.com/t5/K2-Cloud/Import-CSV-file-data-into-List-View/m-p/105590?nobounce#M67

I know you just want to read the contents of the excel value without making use of SQL, but I believe this is the best way to accomplish the feature that you would like. 

Best regards,

Dumisani

Hi  Dumisani,

Thank you for the response,

I tried following the post you mentioned in the comment. They use  CAST('' AS XML).value('xs:base64Binary(sql:column("BASE64_COLUMN"))', 'VARBINARY(MAX)')  to convert base64 string to Plain text. When i use the same for Excel content I am getting Junk value, but it is Working for CSV files.