If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

How would I find out...

Blitzkrieger · 2000-03-20 11:51:00

...the format of a .xls file? Basically I want to hook a cash register up to a PC and program the cr to generate a file instead of printing a report. But there's no point in generating a plain text file unless I want to program an entire accounting package to use it! It has to be something like a .xls so excel can use it.

20-03-2000 12:51pm

#1

Blitzkrieger

Registered Users, Registered Users 2 Posts: 6,660 ✭✭✭

Join Date: August 1999

Posts: 6161

...the format of a .xls file?

Basically I want to hook a cash register up to a PC and program the cr to generate a file instead of printing a report. But there's no point in generating a plain text file unless I want to program an entire accounting package to use it! It has to be something like a .xls so excel can use it.

0

Comments

#2 20-03-2000 6:11pm

kayos

Registered Users, Registered Users 2 Posts: 2,494 ✭✭✭

Join Date: April 1999

Posts: 2356

Export the file to a .csv file i.e. a comma separated file this can instanly be opened by Excel. Just follow the basic rules of EDI for csv and there you go.

KaYoS

0
#3 21-03-2000 1:14am

Blitzkrieger

Registered Users, Registered Users 2 Posts: 6,660 ✭✭✭

Join Date: August 1999

Posts: 6161

cheers

0
#4 21-03-2000 1:29am

Hobbes

Registered Users, Registered Users 2 Posts: 21,264 ✭✭✭✭

Join Date: February 1998

Posts: 18308

Why not export into text then import into Excel and work on it there?

Failing that you can go look at Wotsits site

0