You are viewing limited content. For full access, please sign in.

Question

Question

Is there a setting that will allow for XLS(X) Files to be properly columnized when OCRed, for use in a Workflow loop?

asked on January 31, 2017

I am attempting to import an xlsx spreadsheet with values, and have each "line" in the spreadsheet OCR as a "line" in the OCR Text. Instead, no matter what settings I utilize, it seems to run through the entire first column from top to bottom, then the second column, then the third, etc. This prevents me from getting the values in each column next to each other. The intent is to use pattern matching in a Workflow to read all of these values row by row, and take action on each row.

I know I could use Workflow to set up a data source on this spreadsheet, but I am trying to make it so that the users can simply drag and drop a spreadsheet in to Laserfiche, and then let the Workflow trigger on that file and take action based on the values in each row of the spreadsheet. If anyone has a better idea, I am all ears!

0 0

Answer

SELECTED ANSWER
replied on January 31, 2017

Does the file need to remain as an Excel electronic document? Would it be acceptable to Snapshot the Excel file while obtaining text from the print job and adjusting the text spacing?

0 0

Replies

replied on February 1, 2017 Show version history

I think that will be an acceptable workaround for now. The "Text spacing" feature makes it work. Thanks, Alex.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.