Stats

State Verified Answer
Replies 4
Subscribers 18
Views 1046
Members are here 0

How to merge excel cell in Allgero SKILL using axlSpreadsheet API

SK202607205032 2 months ago

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.

Top Replies

Hoangkhoipcb 2 months ago +1 verified

Hi SK, According to my experience, Allegro SKILL does not support merging cells like Microsoft Excel does. My recommendation is to explore the Allegro SKILL plugin and integrate it with the XlsxWriter…

Parents

+1 Hoangkhoipcb 2 months ago

Hi SK,

According to my experience, Allegro SKILL does not support merging cells like Microsoft Excel does. My recommendation is to explore the Allegro SKILL plugin and integrate it with the XlsxWriter library to generate a native Excel file that fully supports features such as merged cells.

BR,

HoangKhoi
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
0 SK202607205032 5 days ago in reply to Hoangkhoipcb

Hi HoangKhoi,

I successfully import .json and exported the .xlsx file in Python. However, after converting the Python script into an .exe file and using it within the skill, the export failed(didn't find the .xlsx file). Is there any example?thanks a lot!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Hoangkhoipcb 2 days ago in reply to SK202607205032

Hi SK202607205032

Run the code in test.py without using a .exe file.

import xlsxwriter

workbook = xlsxwriter.Workbook("output.xlsx")

worksheet = workbook.add_worksheet()

worksheet.write("A1", "Hello")

worksheet.write("B1", "World")

worksheet.write("A2", 100)

workbook.close()

type this code in cmd Allegro

skill ipcBeginProcess("python test.py" "" "CallbackFun"); can remove CallbackFun

BR,
HoangKhoi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Hoangkhoipcb 2 days ago in reply to SK202607205032

Hi SK202607205032

Run the code in test.py without using a .exe file.

import xlsxwriter

workbook = xlsxwriter.Workbook("output.xlsx")

worksheet = workbook.add_worksheet()

worksheet.write("A1", "Hello")

worksheet.write("B1", "World")

worksheet.write("A2", 100)

workbook.close()

type this code in cmd Allegro

skill ipcBeginProcess("python test.py" "" "CallbackFun"); can remove CallbackFun

BR,
HoangKhoi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

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.