Retrieve words out of excel

[ger.User86Participant]

Hello guys, in the company i work we using an excelfile which i want to get the data from. The problem is there are not just numbers in it, actually most of the concent of the cells are letters or even words. First i tried with interop but to read out the 300×300 field it lasts approx 3 hours. With open xml i tried it but i just found the solution for retrieve numbers out of an excel file, i can’t do words. Is this right? Are there any other options retrieve all the content from a big excel file like this in short time?

im using c#

greetings

• This topic was modified 6 years, 1 month ago by  ger.User86.
• This topic was modified 6 years, 1 month ago by  ger.User86.

[Jim SnyderParticipant]

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

[Eric WhiteKeymaster]

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

[Anonymous]

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