Export to Excel

system · January 14, 2000, 2:29pm

Hi all,

A user here is getting the following error when trying to export her documents to Excel (97)…

Field ‘ColBoDup_2’ already exists in table ‘Query1’.(3380)

Export Failed!

Can anyone give the reason for this with a solution to it ?

Thanks

Ashish

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 2:52pm

Hi:

I believe the error message you are receiving is prompted by the fact that you have two objects similar in name – up to a certain point. (I ran into this problem with dBase export several months ago and suspect it is the same problem here.) The export to MS Excel probably only recognizes a certain number of characters with respect to the objects.

As an example, suppose you have two distinct objects named “Number of Customers” and “Number of Customer Returns.” MS Excel cannot differentiate between the two when it tries to export them. It probably only interprets each as “Number~1” and thus the conflict occurs and the error message generated.

You should determine which two objects have similar names and try to rename one of them in a manner that will still make sense to you. It should export after this change.

Jim Salyers, Jr.
NSWCDD

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 3:24pm

"two objects similar in name "

That doesnt seem to be the problem… I checked the Object names… none are similar. What else could it be ?

Ashish

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 7:06pm

I do know of this solution…but the only problem being… if any of the cell has a null ( blank), it shows up on the XL sheet as #EMPTY.

Ashish

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 10:43pm

boundary="----_=_NextPart_001_01BF5EE0.CF8A758A"

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 10:52pm

Hi Vinay,

I have a similar requirement. Could you send me a copy too?

Thanks,
Swati.

From: “Rao, Vinay (GEP, Contractor)” Vinay.Rao@GEPEX.GE.COM

Hi Listers,
I know of a way you can directly send as BO report as a Excel file either to
User OR Fileserver. It needs a bit of BO Scripting. Just a few lines. I almost
have it offhand. BO doesn’t give this in their HELP files ( they have for .txt, .rtf and html ). I don’t know whether the null fields would come as #EMPTY when you send with this script into DAS.
Ashish, I can send you that script offline and you may want to try that.
Thanks,
Vinay.

Swati Bhatt
InfoSTEP Inc.
http://www.infostep.com

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

system · January 14, 2000, 11:08pm

boundary="----_=_NextPart_001_01BF5EE4.4AC386B8"

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

Listserv Archives (BOB member since 2002-06-25)

system · January 17, 2000, 3:20pm

boundary="----=_NextPart_000_0003_01BF60D4.6C422270"

This is a multi-part message in MIME format.

Listserv Archives (BOB member since 2002-06-25)

system · March 30, 2000, 5:28pm

Hi all
Does anyone has any script (and the steps to implement it…)to automatically export a report from BO to an specific file in excel? Thanks in advance
Brgds
Omar

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:11pm

Is there a way to export the report ,without losing the formatting ,to Excel?
I presume using VBA is the only option. Incase anyone has done this before… pls help.

Rajesh

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:27pm

Thanx … you still do lose the formatting. Also if you have a complex report with many blocks , many variables, it does not work well.

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:28pm

You asked…

Is there a way to export the report ,without losing the formatting ,to Excel?

Me…

Did you try doing a file/save as .txt and opening that in Excel?

Cindy Clayton

Ask WHY until you understand!

Overlooked blessings…
Laughing so hard your sides hurt and you can’t catch your breath… Daydreams…
The feel of a child in your arms…

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:29pm

The easiest way I found is to save the report as .txt and open it in excel

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:47pm

Save your report as html and open it in excel with html.

Bernard

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 1:55pm

I found that best way to preserve formatting is doing “Edit -> Copy All” in BO and then paste into Excel.

Wolfgang

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 2:13pm

I forgot something:

doing a “Copy All” in BO and then paste into Excel not only preserves BO formatting like sections but also - and perhaps more importantly- it also preserves results obtained through operations on the report like filters or ranking. Besides it is the fastest and easiest method.

Wolfgang

Listserv Archives (BOB member since 2002-06-25)

system · March 13, 2001, 10:05pm

“Kumar, Rajesh (PLIC, IT)” Rajesh.Kumar@THEHARTFORD.COM wrote:

Is there a way to export the report ,without losing the formatting , to Excel?
I presume using VBA is the only option. Incase anyone has done this before…
and responded to the suggestion to save as text:
Thanx … you still do lose the formatting. Also if you have a complex report with many blocks , many variables,

it does not work well.

I’ve used a little VBA script to save it as RTF, open the RTF in Word, copy everything, paste it into Excel, and save the resulting file. It’s worked fine for me. If you don’t want to do it by script, you could follow these same steps manually.
… Dudley Horque
Data Warehouse Specialist
NIB Health Funds
384 Hunter Street
Newcastle NSW 2300
AUSTRALIA
E-Mail d.horque@nib.com.au

Listserv Archives (BOB member since 2002-06-25)

system · March 14, 2001, 1:08am

You can do a Copy All (from the Edit menu) and either Paste or Paste Special into Excel. It doesn’t keep the format exactly as in BO (eg. titles are no longer centered across the page, etc.) but the general layout is usually similar enough to save a bit of reformatting.

HTH

Isabel.

From: Kumar, Rajesh (PLIC, IT) [SMTP:Rajesh.Kumar@THEHARTFORD.COM] Sent: Tuesday, March 13, 2001 21:27

Thanx … you still do lose the formatting. Also if you have a complex report with many blocks , many variables, it does
not work well.

The easiest way I found is to save the report as .txt and open it in excel

Is there a way to export the report ,without losing the formatting ,to Excel?
I presume using VBA is the only option. Incase anyone has done this before…
pls help.

Rajesh

NOTE: Replies are now controlled by individual subscribers’ e-mail settings.
Please check the “reply-to” line before sending mail, and note whether you are sending to the entire list, or just to an individual. Report bounces in response to postings to BUSOB-L-Request@listserv.aol.com Web archives: listserv.aol.com/archives/busob-l.html To change service: Mail to listserv@listserv.aol.com with text in body of note

To Unsubscribe: ‘unsubscribe BUSOB-L’ - Vacation Options: ‘set BUSOB-L nomail’ ‘set BUSOB-L mail’

Listserv Archives (BOB member since 2002-06-25)

system · March 15, 2001, 7:25pm

My only compliant with Copy All and Paste is that if you have a large number of rows (more than 1 page) the copy and paste takes a long time. The Copy All seems to have a bug or something but if you do a copy all you will have to wait a few minutes before you can paste, and if the report is large it will be longer than a few minutes. This was a problem in BO 4.1 and I understand it was not fixed in 5.0. I don’t know if it got fixed in 5.1.

Kathy Mahler
Stanford University

At 09:08 AM 3/14/2001 +0800, you wrote:

You can do a Copy All (from the Edit menu) and either Paste or Paste Special into Excel. It doesn’t keep the format exactly as in BO (eg. titles are no longer centered across the page, etc.) but the general layout is usually similar enough to save a bit of reformatting.

HTH

Isabel.

From: Kumar, Rajesh (PLIC, IT) [SMTP:Rajesh.Kumar@THEHARTFORD.COM] Sent: Tuesday, March 13, 2001 21:27

Thanx … you still do lose the formatting. Also if you have a complex report with many blocks , many variables, it does
not work well.

Listserv Archives (BOB member since 2002-06-25)

system · March 15, 2001, 8:33pm

I have tried most of the samples I found on the listserv to export to excel, but I have not found one that will export the totals in a report so that Excel will recognize them as totals. The value is there, but Excel thinks it is another detail line. Therefore, the users have to add back sub-totals, totals etc. Is there anyway to retain the formulas? We will be using BCA to email the Excel spreadsheet to the users. Michele

My only compliant with Copy All and Paste is that if you have a large number of rows (more than 1 page) the copy and paste takes a long time. The Copy All seems to have a bug or something but if you do a copy all you will have to wait a few minutes before you can paste, and if the report is large it will be longer than a few minutes. This was a problem in BO 4.1 and I understand it was not fixed in 5.0. I don’t know if it got fixed in 5.1.

Kathy Mahler
Stanford University

At 09:08 AM 3/14/2001 +0800, you wrote:

You can do a Copy All (from the Edit menu) and either Paste or Paste
Special
into Excel. It doesn’t keep the format exactly as in BO (eg. titles are no longer centered across the page, etc.) but the general layout is usually similar enough to save a bit of reformatting.

HTH

Isabel.

From: Kumar, Rajesh (PLIC, IT) [SMTP:Rajesh.Kumar@THEHARTFORD.COM] Sent: Tuesday, March 13, 2001 21:27

Thanx … you still do lose the formatting. Also if you have a complex report with many blocks , many variables, it does
not work well.

Listserv Archives (BOB member since 2002-06-25)