Home |
Search |
Today's Posts |
![]() |
|
London Transport (uk.transport.london) Discussion of all forms of transport in London. |
Reply |
|
LinkBack | Thread Tools | Display Modes |
|
#1
![]() |
|||
|
|||
![]()
Matt Wheeler wrote:
"David FitzGerald" wrote in message om... I've been asked to produce a series of Excel spreadsheets with train timetable information for a number of National Rail (London only) routes. Besides using the Network Rail journey planner and manually typing/pasting them in, is there any way of getting this information into Excel? It's getting a bit complicated and time consuming! For those TOCs who publish timetables on their website in PDF format, could you do a cut/paste from acrobat reader into Excel ? I tried with one of the SWT timetables. You can cut and paste, but the content gets garbled extensively in the process. Even the Column Select tool doesn't seem to be much use, as it ignores blank entries in the column. Text Select does the same horizontally. Possibly a Visual Basic program could be written to disentangle it, but it doesn't look at all easy. -- Richard J. (to e-mail me, swap uk and yon in address) |
#2
![]() |
|||
|
|||
![]()
In message , Richard J.
writes I tried with one of the SWT timetables. You can cut and paste, but the content gets garbled extensively in the process. Even the Column Select tool doesn't seem to be much use, as it ignores blank entries in the column. Text Select does the same horizontally. Possibly a Visual Basic program could be written to disentangle it, but it doesn't look at all easy. Surely it would be better to invest in one of the conversion utilities available, given the extent of the job? Able2Extract (A2E) is one of those that claims to convert from PDF to Excel (I've not tried it myself): http://www.investintech.com/able2extract.html -- Paul Terry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parking at ExCel | London Transport | |||
Free parking near Excel in Docklands ? | London Transport | |||
TFL Timetables for PDA Pocket Journey Planner | London Transport | |||
New Met line timetables | London Transport | |||
New Route 83 Timetables | London Transport |