Current position:  Home > Default > Won't create Excell sheet accurately

Won't create Excell sheet accurately

Time:November 30
Advertisement
I have reports done in Excell with 4 sheets as pages. they
are all pretty much the same lay-out. All pages show normally when
looked at under print preview for Excell but only 2,3,and 4 convert
to Adobe properly. (I'm using 6.0 Standard). The bottom of 1
doesn't want to show up. I've tinkered a bit and had it show up on
a second page after converting but this is no good. It prints
normally in Excell. Any thoughts would be appreciated or if I can
send the report as an attachment somehow so you can easier see what
I am doing wrong.
Advertisement
The easiest fix is to format the receiving column as Text prior to making your entries.
Another way is to format as "Numeral System", Base: 10, Places: 5. This doesn't work so well if you need the 4 extra digits that some people like to use.
It's also possible to create a Custom Format, but it's rather more involved.
Regards,
Jerry

How can i create  excel sheet with multiple tabs using utl file?

2015-10-11

how can i create excel sheet with multiple tabs using utl file? any one help me?Jaggy, I gave you the most suitable answer on your own thread yesterday Re: How to Generating Excel workbook with multiple worksheetsRead other 7 answers

Create Excel sheet

2015-10-11

I tried to use the Bi Beans to create Excel sheet using CSV for the current used crosstab, no hope...here is the code i used... public void writeExcelFile(DataAccess dataAccess, DataDirector dataDirector){                          try{ PrintWriter ou

Is it possible to create Excel Sheet using OLE automation in App server

-0001-11-30

Hi,    Is it possible to create Excel Sheet using OLE automation in Application server(Open Dataset) Thanks in advance...Unless your application server is on Windows OS, or it is connected to a Windows server by RFC. What is the requirement exactly,

Problem while creating Excel sheet from TSQL

-0001-11-30

Hi, I am trying to create an excel sheet using tsql in production server, script is running without any error however when i am trying to open the excel file it is giving an error that may be the file is corrut or in used by some other process or is

Create Excel sheet using OLE

-0001-11-30

Hi All,        Can any one help me to create an multiple excel sheet in an work book using OLE. I want to create more than 3 sheets in excel, which is default sheets in excel when we one excel.Hi, Check the below sample code. Here I'm downloading the

Creating excel sheet from pl/sql

-0001-11-30

Hi, I need to generate an excel sheet and write the result of a query into it from pl/sql . Is it possible? any idea pls. cheers RRKYou can use the following method -- Write the following code in the emp.sql set serveroutput on set verify off set fee

Jxl api : image creating in sheet.

-0001-11-30

Hi i am using jxl api for creating excel sheet . I have a problem in creating image in sheet , i used below code to creat image: WritableSheet sheet = workbook.createSheet("FirstSheet", 0); sheet.setName("sheet1"); String image="c

Display Excel on browser & read the edited Excel sheet

-0001-11-30

Hi, Till now i was using POI api to create Excel sheet and add data to the sheet. Now we had a requirement to display Excel sheet on browser. User can edit the Excel and on click of Save button, we need to read the data and save it to Database. If i

Excel sheet in  A4 Format

-0001-11-30

Hi, i created Excel sheet A4 format by using[b] poi api but i am facing problem at the time of printing.i have 20 columns in that sheet at the time of printing some columns is coming one page remaining columns coming into second page i want display a

Create link to excel sheet from ssrs

2015-10-11

Hi! I,m trying to create a link from SSRS to an excel sheet that is placed on a server (in my case the same server as Sql is running) \\csedb30\BusinessWarehouse\VDC\Actual\exceltest.xlsx.  I have made links to url sites and to other reports within r

How to create new Sheet in Excel file and write into it

2015-10-11

Hi to all, my requirement is this: I have an excel file (.xls) with multiple sheets (three sheets for precision: sheet1, sheet2 and sheet3). I must create in the same excel file new sheet, say sheet4, read data from sheet1, sheet2 and sheet3 and writ

Create a visual web part which get data from excel sheet and import it into sql server database in sharepoint 2010 (development)

2015-10-11

Hi, I want to create a visual webpart which will read data from excel sheet and import it in to sql server database.(using sharepoint development) I want to do it using visual webpart. Please help to solve the issue. Thanks in advance! Regards RajniH

Create Indesign book from paths in an excel sheet

2015-10-11

Hello All I have started to learn some scripting, and want to know if it is possible to read information from Excel sheet? In this case it is paths to Ind files. Today we are working with several documents which we compile into a book, this to create

Problems creating a PDF from Word containing a Excel sheet

2015-10-11

When I want create a PDF (Acrobat 8 or 6) in Word 2007 it always happens that the excel sheet in the word document is a solid black box instead of the excel sheet in the created PDF. Anyone else had that problem and who can help? Thanks alot!if you h

Can we create Multi Tabbed excel Sheet using Crystal Reports 2008

-0001-11-30

Hi,   We want to create a Crystal Report which will export the output as multiple Tab's ( we can use sub reports).  Can we create a Multi Tabbed excel Sheet using Crystal Reports 2008 ( not  Crystal reports Basic 2008). Please share any information/l

How to create an Excel sheet in side the Studio, and wirte somethiing

-0001-11-30

actually i want to create one excel sheet and in that i want to place some data. can anybody help me..?Hi, In addition to the post I made on http://forums.bea.com/bea//thread.jspa?forumID=600000022&threadID=300003034 to add a template that has the he

Unknown column in the excel sheet created using Export to Excel

-0001-11-30

Hi, I created an excelsheet for the table data using the below link https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-technology/wd%20java/wdjava%20archive/exporting%20context%20data%20into%20excel%20usi

How to create a universe on excel sheet

-0001-11-30

hi, i am trying to create a universe on four excel sheets. so in designer i clicked on new . i gave the universe name  not it is asking for coonection parameters  i selected spreadsheet and odbc connection . but  i am getting connection failed. can a

What is the class for creating the excel sheet in the java

-0001-11-30

please say the class for creating the excel sheet in java (servlets,jsp)You can also cheat and rename a html file to xls. Just use standard html tables. Should be able to use google to find a working example.Read other 4 answers