Insert dataview from XML (Excel spreadsheet)

C

costabella

I'm a newcomer to FP/SharePoint/etc. When I insert a dataview into a
web part page, I click on show data before I insert. If my spreadsheet
had 3 rows, the data view details shows Rows 1/3. I highlight the "Rows
1/3". The inserted dataview adds a header row with entries such as

Cell[1]/Data

How do I get the first row to be the headers so I can add filtering of
the columns from the style menu?

original spreadsheet

SSN Name Wage Weeks
111 Suss 50 10
222 Webster 30 5

resulting dataview

Cell[1]/Data Cell[2]/Data Cell[3]/Data Cell[4]/Data
SSN Name Wage Weeks
111 Suss 50 10
222 Webster 30 5

Regards,
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data manipulation help 9
INSERT to excel file 4
type mismatch error in macro in excel 0
add rows to a word table from a dataview or datatable 1
use list of criteria in filter 0
add mergefields to exsting word 2013 2
Highlighting reaccuring info in a spreadsheet 2
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1

Top