save as") or copy the contents (copy & paste), the contents of it will not be schown in Excel 1:1.">
H+H Software GmbH
H+H Software GmbH
Deutsche Sprache English Language Login
  Business area | Reference customer | Case studies | Events | Contact | Terms | Imprint |
H+H Software GmbH
Home
Product overview
NetMan
NetMan Desktop Manager
HAN
Virtual CD
H+H Projects
our partners
H+H Events
Events
H+H Service
H+H Support
Applications and their characteristics
Knowledgebase
PDF Documents
H+H Image Database
Newsletter
Knowledgebase-Eintrag #1144 NetMan
HAN
NetMan5
In Excel how can I import a main table from the NetMan/HAN Statistics?
If you save the main table as a dbf file ("File -> save as") or copy the contents (copy & paste), the contents of it will not be schown in Excel 1:1.

You can open 1:1 a main table in Excel by creating a report in the Statistics: File -> create report. The format of storage is unimportant.

The file has to be opened through the opening dialog in Excel so that the test import wizard is started (ith a copy & paste the file will be opened unformatted). Excel then interprets entries like "1.57" as "Jan 57", etc. When the contents are partly interpreted as a date, the columns have to be explicitly imported as text. You can define this in step 3 of the text import wizard.

As of NetMan 3 a main or parallel table can be opened in Excel using File -> Save as Excel file.

As of HAN 3 and NetMan 5 files can be exported in CSV format only (export name doexport).

04.02.19, Hartmut Mäcker
Knowledgebase
Search:

Knowledge area: