View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
 
Posts: 90
Default Formatting Cells/Columns in Excel 97

Excel does not have that kind of byte width designation on fields. Each
cell will hold any size of data you put there (up to certain very large
limits) without any width specification. You can also explore Excel
cell formatting by choosing the menu item "Format" and clicking "Cells."

On Thu, 28 Aug 2003 01:38:40 -0700, Daryl Ho wrote:

Actually I'm supposed to extract some data from an InterBase database
server (using Borland Delphi) and dump them into an excel file.

However the exported excel field requirements I was given stated all
these stuffs like Column A = GENERAL (Size 6), Column B = GENERAL (Size
4), Column C = TEXT (Size 20) etc. Thus it's somewhat like a fixed width
column excel file that my client can import into their own programs.

I'm just real puzzled if Excel 97 is able to format the columns to this
extent (fixed width and different field type) so I thought I had better
snoop around here first before I call them back.

Hope this clears up the air. Thanks!