Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel pivot table with XML data source

trial03

trial03

Technical User
Oct 9, 2011
10
MY
Dear all,

Previously I use the vfp table as the data source of the excel pivot table.

oExcel = CREATEOBJECT("excel.application")
oWorkBook = oExcel.workBooks.add()

oTargetSheet = oWorkBook.sheets.add()
oTargetRange = oTargetSheet.range(mRange)

oPivotCache = oWorkBook.pivotCaches.add(2) && External data

oPivotCache.connection = "OLEDB;Provider=vfpOleDb.1;data source = c:\erp"
oPivotCache.commandText = "SELECT * FROM tRepData"

oPivotTable = oPivotCache.createPivotTable(oTargetRange,"pivotTable")

oPivotTable.PivotFields("csName").orientation = 1&& row
oPivotTable.PivotFields("cusName").orientation = 1 && row
oPivotTable.PivotFields("days").orientation = 2 && column
oPivotTable.PivotFields("cntDays").orientation = 4 && data

but nowadays most of the users install 64bits of MsOffice causing compatibility issues with VFP 32bits.


Thinking to export vfp data to xml and make it as the data source of the excel pivot table. Any idea how to do it?


Thanks and regards,
 
Sort by date Sort by votes
cursortoxml()

If you're using an old VFP6 version: https://webconnection.west-wind.com/docs/_s8x02fe2w.htm
In an old version that you get from https://client-tools.west-wind.com/, look at the right side:
Older unsupported versions for:

Click to expand...
OR simply output XML yourself, it's not rocket science to have XML tags, it's all just text and what ou need is STRTOFILE or even just FWRITE.
 
Last edited:
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

SitesMasstec
  • Locked
  • Question
Combobox populated with data from a table 1
Replies
8
Views
2K
igorsandler
igorsandler
SitesMasstec
  • Locked
  • Question
Report with no Data Environment 1
Replies
15
Views
548
SitesMasstec
SitesMasstec
bharons
  • Locked
  • Question
SQL Server data processing with VFP 8 1
Replies
8
Views
713
bharons
bharons
Filip Brnic
  • Locked
  • Question
Importing XML data into a cursor inside a form
Replies
7
Views
1K
tomk3
tomk3
SitesMasstec
  • Locked
  • Question
Create a table with Tag indexes 1
Replies
13
Views
1K
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top