>Hello, I'm trying to process an xlsx workbook with 3 sheets and am having some difficulty.
>
>How are people processing xlsx these days?
>
>I'm aware of the oledb solutions including Craig Boyd's excellent sample code, but Excel oledb drivers aren't on every machine and we're told not to use oledb any more.
>
>I'm also aware of Greg Green's excellent XLSX Workbook which can process all 3 sheets exactly as I'd like- but some customer sheets contain customXML Type that leads to a SET STEP ON in R32.
>
>In addition and as a separate issue, I'm experiencing regular C0000005-type crashes or even direct dropouts out of VFP when opening a small xlsx using the XLSX Workbook class. This is intermittent, even with the same workbook.
>
>I'll download a fresh R32 copy and try again, but does anybody have advice on ways to process these files reliably? The Set Step on I see is in this section of code:
>
> *-* Get the defined relationship files for this workbook; process each file
>
>when the type is customXML that is not caught by the Type CASE statement that proceeds to an OTHERWISE set step on.

Give a try to importfromxlsx :

http://praisachion.blogspot.com/