Retrieve words out of excel

Home › Forums › SpreadsheetML › Retrieve words out of excel

Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • October 5, 2018 at 1:17 pm #7661
    Jim Snyder
    Participant

    Can you post your Interop code? 300 x 300 is pretty small and even Interop should be fast on that.

    October 5, 2018 at 3:33 pm #7662
    Eric White
    Keymaster

    Take a look at the SmlDataRetriever module in Open-Xml-PowerTools.

    October 6, 2020 at 11:48 am #9736
    Anonymous
    Inactive

    Depending on where you want to start an extraction, use one of these formulas:
    LEFT function – to extract a substring from the left.
    RIGHT function – to extract text from the right.
    MID function – to extract a substring from the middle of a text string, starting at the point you specify.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.