<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How To Import(.PDF,.Docx,.Txt Files) into Excel? in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72243#M24848</link>
    <description>Can Someone Suggest How to Import (.PDF ,.Docx, .Txt Files) into Excel? Are is there any VBO?</description>
    <pubDate>Thu, 01 Feb 2018 19:10:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-02-01T19:10:00Z</dc:date>
    <item>
      <title>How To Import(.PDF,.Docx,.Txt Files) into Excel?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72243#M24848</link>
      <description>Can Someone Suggest How to Import (.PDF ,.Docx, .Txt Files) into Excel? Are is there any VBO?</description>
      <pubDate>Thu, 01 Feb 2018 19:10:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72243#M24848</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-02-01T19:10:00Z</dc:date>
    </item>
    <item>
      <title>Hi Palaniappan,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72244#M24849</link>
      <description>Hi Palaniappan,
Importing a text file into Excel is the easiest.
The big question is what the format is of your text file is: different columns seperated by comma (so it's in fact a CSV) or you first need to parse it?
WIth the object Utility - File Management with the action Read All Text from File or Get CSV Text As Collection you should be able to handle those cases. And then you can use the Excel VBO to write to the excel file
Regarding the word file: The same question applies: What do you want to have from it? Transfer the tables from the word document to an Excel file, or just copy paste the text?
PDF files are a bit more tricky, but there is a BluePrism tutorial on how to deal with them.
Also the forum&amp;nbsp;contains quite some info and tips &amp;amp; tricks.
Good luck&amp;nbsp;</description>
      <pubDate>Fri, 02 Feb 2018 15:17:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72244#M24849</guid>
      <dc:creator>BastiaanBezemer</dc:creator>
      <dc:date>2018-02-02T15:17:00Z</dc:date>
    </item>
    <item>
      <title>Hi bastiaan.bezemer2, Can…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72245#M24850</link>
      <description>Hi&amp;nbsp;bastiaan.bezemer2, Can you&amp;nbsp;please share the link of these videos (extract content from a pdf file)?</description>
      <pubDate>Tue, 13 Feb 2018 15:17:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-To-Import-PDF-Docx-Txt-Files-into-Excel/m-p/72245#M24850</guid>
      <dc:creator>YogeshAnand</dc:creator>
      <dc:date>2018-02-13T15:17:00Z</dc:date>
    </item>
  </channel>
</rss>

