How to read excel file content using workflow

  • 30 January 2020
  • 2 replies
  • 113 views

I'm using K2 Five 5.3 and would like to know if there are smartobject to read excel file (attachment of a list item) and use it content. I searched and saw Function Browser supports Excel functions but they are no longer supported in current version. Thanks!

 

https://help.k2.com/onlinehelp/K2Five/UserGuide/current/default.htm#LegacyDesigntools/K2_for_VisualStudio_K2_Studio/4.Workflow/InlineFunctions/FB_Excel.htm%3FTocPath%3DCreate%7CLegacy%2520Design%2520Tools%7CK2%2520for%2520Visual%2520Studio%7CWorkflow%7CObject%2520Browser%7CFunction%2520Browser%7C_____4


2 replies

Hello,

There are some Community Tools that integrate with Excel and should be able to accomplish what you are looking to do. Note that community tools are not supported by K2. Here are a few examples from the K2 Market.

https://community.k2.com/t5/K2-blackpearl/Excel-Import-Service-Broker/ba-p/65814

https://community.k2.com/t5/K2-blackpearl/Excel-Controls/ba-p/1105

https://community.k2.com/t5/General-K2-Utilities/EXCEL-AS-SMO-SERVICE-BROKER/ba-p/86040

Hi tkunohim,


 


The function that you have mentioned in your post can still be used if your environment has been upgraded from 4.7.


The legacy components are no longer available inew installations of K2 Five. These legacy tools may also not be available, supported, or behave as described, in future updates or versions of K2


 


Hope this helps


 


Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such
using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.


 


Cheers,


Kate


 


K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.

Reply