Karaoke Scene's Karaoke Forums
https://mail.karaokescenemagazine.net/forums/

printing with Excel question
https://mail.karaokescenemagazine.net/forums/viewtopic.php?f=1&t=14464		 Page 1 of 1
Author:  dbros9 [ Thu Aug 28, 2008 10:07 am ]
Post subject:  printing with Excel question
i have 20 k songs in an excel spreadsheet (artis and song in alpha order)- i want to print is but have 4 columns on each printed page - example - songs are in alpha order - so now if i print it will do 50 per page - what i want to do is have song 51 -100 on page 1 - so basically 4 columns in alpha order instead of 2
any thoughts??

Thanks
Author:  knightshow [ Thu Aug 28, 2008 10:53 am ]
Post subject:  Re: printing with Excel question
It's been so long since I've worked with Excel. I can tell you I can do what you want to do with Word... That's easy with their column feature per page!
Author:  dbros9 [ Thu Aug 28, 2008 11:08 am ]
Post subject:  Re: printing with Excel question
cool - do u know how i would import the excel file into Word and where column feature per page is
tks
Author:  knightshow [ Thu Aug 28, 2008 11:18 am ]
Post subject:  Re: printing with Excel question
Word allows you to easily Import the excel spreadsheet data. I personally would just select the columns and then COPY them (into clipboard), and then PASTE them in Word.

As for the column feature in Word, click "Format" and then go to Columns. The process will walk you through it.
Author:  dbros9 [ Thu Aug 28, 2008 12:51 pm ]
Post subject:  Re: printing with Excel question
do u know what karaoke songlist programs are out there that can import MS excel spread sheets
Author:  knightshow [ Thu Aug 28, 2008 1:42 pm ]
Post subject:  Re: printing with Excel question
not me personally.

HOWEVER, Chip from DKUSA has a songbook program where he will convert your excel songbook to his format.

Called Speedbook
Author:  Mike W. [ Thu Aug 28, 2008 3:21 pm ]
Post subject:  Re: printing with Excel question
If you happen to have MS Access I would port over your Excel data to an Access table and set up a 4 column report. Of course, if you happen to have Access I would STRONGLY recommend using it for songbook creation and scrapping Excel anyway.
Author:  stogie [ Thu Aug 28, 2008 3:34 pm ]
Post subject:  Re: printing with Excel question
I'm interested in knowing how to set up a 2 or 4 column report in Access. I imported a test database into access with just two fields, Artist and Title. I''d like to print books by artist or by title with two column listings per page. Any help with this would be greatly appreciated.
Author:  Lonman [ Thu Aug 28, 2008 3:44 pm ]
Post subject:  Re: printing with Excel question
For a 2 column. First you'd set it up in page setup. Margins .5" all the way (for more data per page. Then click columns. Number of columns you want. 0" spacing on both. Width 4" Height 0". Down then across.

You need to play with the detail in order to get it set right. Try to keep everything within the 4" range.
This is mine set up like above - artists
http://www.lonmanproductions.com/nodupart.pdf - I just noticed my sizing is just a shade off on the right side.
Title
http://www.lonmanproductions.com/nodupsong.pdf
Author:  stogie [ Thu Aug 28, 2008 11:58 pm ]
Post subject:  Re: printing with Excel question
Wow, I didn't realize there was a Page Setup just like in Word and Excel. I changed to two columns and spaced them 1/2" apart and resized the column width and whahlah, two columns. FANTASTIC! Thanks Lonman

So if I may, I have another question. At the top of the second listing there are several songs from the listing under the Artis heading, but no BOLD artist listing at the top of the second column because it was a continuation. Is there some sort of conditional statement that needs to be put there? In other words, how do you tell access to place the Artist heading if a multiple song listing extends up to the next column?

All t[/i]his doesn't seem worth the effort other than as a challenge and maybe I can learn something useful. I can see that book software is well worth the money since I suck at programming. If had any skill at all at programming I would have jumped in and made a little program or some macros to do it and it would be done already. I really admire people who can program and make a computer do things. I think it's an amazing skill.
Author:  DJ Swirl [ Fri Aug 29, 2008 7:35 am ]
Post subject:  Re: printing with Excel question
Hey Lonman,

Just took a quick glance at your book and noticed an error. You have Del Amitri listed in the As. It's actually the name of the band, which would put it under D. Not sure why that caught my eye, and I strongly doubt any of their songs ever get sung, but thought I'd mention it for your next go 'round.
Author:  Lonman [ Fri Aug 29, 2008 10:00 am ]
Post subject:  Re: printing with Excel question
DJ Swirl @ Fri Aug 29, 2008 8:35 am wrote:
Hey Lonman,

Just took a quick glance at your book and noticed an error. You have Del Amitri listed in the As. It's actually the name of the band, which would put it under D. Not sure why that caught my eye, and I strongly doubt any of their songs ever get sung, but thought I'd mention it for your next go 'round.


Thanks, can't get them all - I didn't know, sounded like a name! Will fix. :D
At least it isn't as bad as seeing Skynyrd, Lynyrd in some books i've perused..... :mrgreen:
Author:  dbros9 [ Tue Sep 02, 2008 10:07 am ]
Post subject:  Re: printing with Excel question
Looks like KJPRO is the only program I found that will do an Excel import - anyone know of any other songbook software that has the function to import Excel files

Thanks
Author:  Catseyeview [ Tue Sep 02, 2008 11:35 am ]
Post subject:  Re: printing with Excel question
FastTracks will also import/export Excel spreadsheets, awesome lil proggy. You can also publish directly to your website with it 8)
Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/