Jeff
Thu Nov 04 08:57:59 CST 2004
If you're importing from a database, try skipping Excel entirely.
Use the Pivot Sheet web part (from Office Web Components). Bind it to your
database using the query you want.
Create addtional pages/web parts for different queries (views).
"mark" <mark@discussions.microsoft.com> wrote in message
news:53BA1BF0-FB2E-4391-9EC0-D1D4F6C28CF2@microsoft.com...
>I try to decribe my problem and would be happy for a way to do best.
> every week I get an excel.xls file containing about 10.000 lines and about
> 90 colums. it is an report of the buisness week. As I did before is
> looking
> at everything suspecious by using excel filters one after one.
> first I wanted to import the file to a wss list and create different
> sheets
> of filters (don´t know the English term) but the file is to big to import
> (to
> many colomns of same data type)
> then you gave me the hint so share the file to and webpart which sounds
> good.
> the webpart has do give me maybe 10 different view on the same database so
> check if everything has been ok the week before.
> in special that might be a look to the unproductive ours, a look on
> everything concernig one project, a look on illness day etc.
> it would be fine if these (different webparts) where useful with the data
> of
> next week.
> the way we do now is really the worst, having a look at everything one
> after
> on in excel.
> by
> mark
>
>
>
> "Jeff Webb" wrote:
>
>> The XML web part just displays XML. What I thought you wanted to do was
>> share a data set containing too many columns to put in a list. An XML
>> file
>> can do that and retain the structure.
>>
>> If you want to present that data in chart form, there are a lot of
>> choices:
>> You can use an Excel workbook that reads the shared XML, create a web
>> part
>> to chart the XML, create a HTML page that includes a control that charts
>> the
>> XML, etc.
>>
>> You might want to look at the Office Web Components (web parts). I don't
>> see
>> any charting parts there -- I bet there are some available though.
>>
>> Good luck,
>>
>> Jeff
>> "mark" <mark@discussions.microsoft.com> wrote in message
>> news:C090B35A-6BF0-4504-B7DD-371010DB0DE3@microsoft.com...
>> > thanks for the idea but I suppose I´m not yet used to this possibility.
>> > I did as the following:
>> > I saved the excel chart as excel.xml kalkulation chart (xml data chart
>> > was
>> > not possible) then I created a webpart-page and pulled the xml webpart
>> > inside.
>> > I loaded the excel.xml to a dokument library on the same page an gave
>> > the
>> > url to the webpart.
>> > after I saved all there was a lot of data without order and strukture
>> > in
>> > my
>> > webpart.
>> > what did I wrong?
>> >
>> >
>> >
>> > "Jeff Webb" wrote:
>> >
>> >> Another alternative would be to store the data as a single XML file
>> >> and
>> >> share that file instead of trying to fit it all into an SP list.
>> >>
>> >> You can do a lot of the same things with XML that you can with lists
>> >> in
>> >> both
>> >> Excel and SP, however it's a very different interface and requires a
>> >> change
>> >> of approach.
>> >>
>> >> "mark" <mark@discussions.microsoft.com> wrote in message
>> >> news:3C2526A9-7E03-4314-8840-32448562830D@microsoft.com...
>> >> >I already did but I have some more than 90 culumns. to change all
>> >> >their
>> >> > properties means to loose information quality. thanks a lot for
>> >> > posting
>> >> > but I
>> >> > think I will have to split the chart.
>> >> > the problem is: the chart it is a weekly report an if I cannot write
>> >> > a
>> >> > makro
>> >> > I have to do all the steps to prepare weekly .....
>> >> >
>> >> > mark
>> >> >
>> >> > "Karsten Grombach" wrote:
>> >> >
>> >> >> not as far as I know. you could cast some of your numeric fields
>> >> >> into
>> >> >> text..
>> >> >>
>> >> >> "mark" <mark@discussions.microsoft.com> wrote in message
>> >> >> news:F6851BB7-2BF3-40F4-883F-A0F70B4E637F@microsoft.com...
>> >> >> > I thought of something like that but I cannot change my entry
>> >> >> > chart.
>> >> >> > Is
>> >> >> there
>> >> >> > any possibility to higher the possible column account in the
>> >> >> > portal
>> >> >> > administration? (just of simple fields with number and currancy)
>> >> >> > thanks
>> >> >> >
>> >> >> >
>> >> >> > "Karsten Grombach" wrote:
>> >> >> >
>> >> >> > > it seems as though you excel sheet hast too many columns.
>> >> >> > > sharepoint
>> >> >> > > has
>> >> >> a
>> >> >> > > limit to the number of columns which a list can have..
>> >> >> > >
>> >> >> > > excerpt from
>> >> >> > >
>> >> >>
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/sharepoint/wsstshoo.mspx
>> >> >> > >
>> >> >> > >
>> >> >> > > Windows SharePoint Services specifies limits for the number of
>> >> >> > > columns
>> >> >> of a
>> >> >> > > certain type that you can create in each list or library. The
>> >> >> > > following
>> >> >> > > table lists the limits by column type.
>> >> >> > >
>> >> >> > > Column Type Maximum Number
>> >> >> > > Single line of text AND Choice (Drop Down Menu or Radio
>> >> >> > > Buttons)*
>> >> >> > > 64
>> >> >> > >
>> >> >> > > Multiple lines of text AND Choice (Checkboxes (allow multiple
>> >> >> sections))*
>> >> >> > > 32
>> >> >> > >
>> >> >> > > Number AND Currency*
>> >> >> > > 32
>> >> >> > >
>> >> >> > > Lookup
>> >> >> > > 16
>> >> >> > >
>> >> >> > > Yes/No
>> >> >> > > 16
>> >> >> > >
>> >> >> > > Calculated
>> >> >> > > 8
>> >> >> > >
>> >> >> > >
>> >> >> > > *In rows marked with an asterisk (*), the number given is the
>> >> >> > > total
>> >> >> > > for
>> >> >> all
>> >> >> > > columns of both of the types in the row combined. For example,
>> >> >> > > you
>> >> >> > > can
>> >> >> > > create 16 Number and 16 Currency columns, or 30 Number columns
>> >> >> > > and
>> >> >> > > 2
>> >> >> > > Currency columns, but not 32 Number columns and 32 Currency
>> >> >> > > columns.
>> >> >> > >
>> >> >> > > Note When you create a list or library, the single line of
>> >> >> > > text
>> >> >> > > column
>> >> >> > > Title is automatically created. You can customize this column,
>> >> >> > > but
>> >> >> > > not
>> >> >> > > delete it.
>> >> >> > >
>> >> >> > > karsten
>> >> >> > >
>> >> >> > >
>> >> >> > > "mark" <mark@discussions.microsoft.com> wrote in message
>> >> >> > > news:EAE85EF0-25A2-45D9-AACF-7B479689BE76@microsoft.com...
>> >> >> > > > I tryed to import a bigger excel file (data content
>> >> >> > > > A1:CE12000)
>> >> >> > > > but
>> >> >> the
>> >> >> > > > infomation was " the maximum count of field with the same
>> >> >> > > > type
>> >> >> > > > of
>> >> >> > > > data
>> >> >> is
>> >> >> > > > reached" and I could not import the file. Can anybody help ?
>> >> >> > > > (sorry for my English)
>> >> >> > > >
>> >> >> > >
>> >> >> > >
>> >> >> > >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>