Converting to Excel

Forum for the PDF-XChange Editor - Free and Licensed Versions

Moderators: TrackerSupp-Daniel, Tracker Support, Vasyl-Tracker Dev Team, Sean - Tracker, Paul - Tracker Supp, Chris - Tracker Supp, Tracker Supp-Stefan, Ivan - Tracker Software

Post Reply
Deborah Tumpak
User
Posts: 1
Joined: Thu Jan 02, 2020 9:35 pm

Converting to Excel

Post by Deborah Tumpak » Wed Jan 15, 2020 4:36 pm

Hello

I just PDF-Xchange to convert pdf files to Excel most of the time. I am often working from multi-page pdfs, is there a setting so that it will convert to a single page Excel, rather than a tab for each page?

The old pdf converting software I used I could do that.

User avatar
Paul - Tracker Supp
Site Admin
Posts: 4999
Joined: Wed Mar 25, 2009 10:37 pm
Location: Chemainus, Canada
Contact:

Re: Converting to Excel

Post by Paul - Tracker Supp » Wed Jan 15, 2020 4:51 pm

Hi Deborah,

welcome to the Tracker forums, and thanks for the post.
Unfortunately we do not have such a feature in the current build, although it is in the pipeline. We have an official Feature Request for this, and while for internal use only, referring to RT#4050: FR: Export to excel single sheet here (in this forum thread) will mean any support staff member can get you a status update.

Currently the item is "Open", a developer is assigned the task and it is being worked on. I have asked if there is an ETA for this and will post here when i hear.
_________________
If posting files to this forum - you must archive the files to a ZIP, RAR or 7z file or they will not be uploaded - thank you.

Best regards

Paul O'Rorke
Tracker Support North America
http://www.tracker-software.com

Kamm
User
Posts: 1
Joined: Thu Jan 30, 2020 5:05 pm

Re: Converting to Excel

Post by Kamm » Thu Jan 30, 2020 5:45 pm

When you export a multi page pdf to excel each page will be on a separate tab with no way to combine the data? Please tell me this is not correct. Right now this is what I see on my docs and sounds like what the original post was asking. It makes no sense to ever set something up like that. I have too much data to combine manually.

I'll be sure to thank my IT guys for buying something for the entire firm that is useless. :roll:

User avatar
TrackerSupp-Daniel
Site Admin
Posts: 3438
Joined: Wed Jan 03, 2018 6:52 pm

Re: Converting to Excel

Post by TrackerSupp-Daniel » Thu Jan 30, 2020 6:11 pm

Hello Kamm,

Unfortunately, as Paul said above, we do not currently have such a feature, so yes, it is currently intended that there is no method to do this. We have offered conversion to Excel for years now, and have only seen a minute number of requests for such an addition to the feature thus far. We are looking to implement this function in the future, but do not have a timeline for its implementation yet.

I am sorry to hear that you are displeased with the product. We do always offer the software as a full functioned free download for evaluation purposes, so that functions like this can be tested before a purchase is made.

Kind regards,
Daniel McIntyre
Support Technician
Tracker Software Products (Canada) LTD

Support: <Support@tracker-software.com>
Sales: +1 (250) 324-1621
Fax: +1 (250) 324-1623

User avatar
Vasyl-Tracker Dev Team
Site Admin
Posts: 1983
Joined: Thu Jun 30, 2005 4:11 pm
Location: Canada

Re: Converting to Excel

Post by Vasyl-Tracker Dev Team » Thu Jan 30, 2020 10:16 pm

Hi Deborah and Kamm.

We will try to implement such feature in the near future. Temporarily you may try to use in Excel the following VBA-script:

Code: Select all

Sub mergeSheets()
    'Define variables:
    Dim book As Workbook
    Dim firstSheet As Worksheet
    Dim sheetsCount As Integer
    Dim i As Integer
    Dim p0 As Range
    Dim p1 As Range
    
    Set book = Application.ActiveWorkbook
    
    If book.Worksheets.Count = 1 Then Exit Sub
    
    Set firstSheet = book.Worksheets(1)
    
    For i = 2 To book.Worksheets.Count
    
        book.Worksheets(i).UsedRange.Copy
        
        Set p0 = firstSheet.Range("A1")
        
        Set p1 = p0.Offset(firstSheet.UsedRange.Row + firstSheet.UsedRange.Rows.Count + 1, 0)
        
        p1.PasteSpecial xlPasteAll
        
    Next i
    
End Sub
- this script merges all sheets to the first one, by appending each content to the end. Also here are some videos how to use this script in Excel:
https://www.youtube.com/watch?v=rD2-mSbTuL0
https://www.youtube.com/watch?v=dmdolFcS-fI

And simple workbook that shows how this script works:
MergeAllSheetsToFirst.zip
(20.42 KiB) Downloaded 12 times
(the Excel will warn you that document has macros and you need to allow it, if you want to see how it works)

HTH.
Vasyl Yaremyn
Tracker Software Products
Project Developer

Please archive any files posted to a ZIP, 7z or RAR file or they will be removed and not posted.

Post Reply