Stats

  • State Not Answered
  • Replies 2
  • Subscribers 20
  • Views 304
  • Members are here 0
More Content

How to merge excel cell in Allgero SKILL using axlSpreadsheet API

SK202607205032

I just using axlSpreadsheetInit() to write excel file, but I don't know how to merge cell,example as the picture below.

Is there any suggestion? Thanks a lot.

Parents
  • 0

    Hi,

    Merging cells in an XML file can be done quite easily using the following approach:

    • Read the XML file again using the infile function.
    • Iterate through each row and store the row data.
    • When reaching the target row and cell to be merged, add MergeAcross according to the Excel XML syntax.
    • Continue reading the file until reaching the last line.
    • Save the modified file.

    Luan

Reply
  • 0

    Hi,

    Merging cells in an XML file can be done quite easily using the following approach:

    • Read the XML file again using the infile function.
    • Iterate through each row and store the row data.
    • When reaching the target row and cell to be merged, add MergeAcross according to the Excel XML syntax.
    • Continue reading the file until reaching the last line.
    • Save the modified file.

    Luan

Children
No Data
Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.