Export to excel journal
Export to excel journal
(OP)
Hi guys,
I'm searching for journal solution to export columns from Assembly Navigator to Excel. I want to have this in one button.
I was trying this, but this don't want to work
Public excelApp As Excel.Application
Public excelBook As Excel.Workbook
Public excelSheet As Excel.Worksheet
Any help? Direction? Solution?
NX 6 and Excel 2007
I'm searching for journal solution to export columns from Assembly Navigator to Excel. I want to have this in one button.
I was trying this, but this don't want to work
Public excelApp As Excel.Application
Public excelBook As Excel.Workbook
Public excelSheet As Excel.Worksheet
Any help? Direction? Solution?
NX 6 and Excel 2007





RE: Export to excel journal
RE: Export to excel journal
RE: Export to excel journal
Public excelApp As Excel.Application
Public excelBook As Excel.Workbook
Public excelSheet As Excel.Worksheet
you need
Imports Microsoft.Office.Interop
now Microsoft.Office.Interop is not a library supported by journalling. Therefore to use the above commands you need to build it as a dll.
Regards
Frank Swinkels
RE: Export to excel journal
my code get err in line 3 with spreadsheet_name
CODE --> .Net
from NXOPEN .Net Api
int UF_XS_extract_spreadsheet
(
char * spreadsheet_name,
char * file_name
)
char * spreadsheet_name Input Spreadsheet object name:
"MODELING_SHEET" - modeling spreadsheet data
"DEFAULT_SHEET" - Gateway spreadsheet data
"PART_FAMILY_SHEET" - Part Family spreadsheet data
How to define "char * spreadsheet_name"? Or how to get object MODELING_SHEET?
Any help?
RE: Export to excel journal
The following code was tested on NX 7.5 and Excel 2010.
CODE
www.nxjournaling.com
RE: Export to excel journal
I made something similar, I could export txt file with Plist.ListToFile function.