Extend / AcuCOBOL Discussions

Home

Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

State Verified Answer
Replies reply
1
Subscribers subscribers
11
Views views
286
Users 0 members are here

Related

Options

Excel

Doc 11 months ago

Can a print file be saved as a xlsx (Excel) file somehow via a cobol program? On Version 10.5.0.

Top Replies

Claudio Contardi 11 months ago +1 verified

Good morning, Doc . ACUCOBOL-GT does not include a native way to save a file as an Excel file. You can define the file as a LINE SEQUENTIAL file, give it a name with a ".csv" file extension, and organise…

Verified Answer

0 Claudio Contardi 11 months ago

Good morning, Doc .

ACUCOBOL-GT does not include a native way to save a file as an Excel file.

You can define the file as a LINE SEQUENTIAL file,
give it a name with a ".csv" file extension,
and organise the fields so that they respect the CSV syntax.
Once done, you'll be able to open/import this file from your Excel.

Alternatively, you can call the Excel methods and classes directly from within the ACU program,
to create a proper Excel file.

Samples of codes are available in this Community.
For example: https://community.microfocus.com/cobol/acucobol/f/forumid-20/357777/saving-excel-workbook-to-specified-file

Regards.

Claudio Contardi

Lead Technical Support Specialist
Rocket Software, Italia
RocketSoftware.com
linkedin.com/rocket-software
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel

Resources

Learning Services

Partner Programs

Privacy

Compliance

Help

Company

Privacy Policy
Terms of Use
Cookies Preferences

Accessibility
Anti-Slavery Statement

Support
Contact Us

Careers
Code of Business Conduct and Ethics

The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.