New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Existing VBA code integration #126

Closed
kacear opened this Issue May 28, 2014 · 2 comments

Comments

2 participants
@kacear

kacear commented May 28, 2014

First of all, thanks for writing such a useful tool.
I have been using this tool for my small project and went through documentation several times now.

I have feature request/question on VBA code (so there is no sample code here).
I couldn't find any comment related to VBA code.
I have existing VBA code and want to use this code in XlsxWriter created code.

For example, (please ignore any syntax here)
I have this code in VBA macro.

sub calculate(a, b):
  return a+b
end sub

In my XlsxWriter created Excel file,
I want to write cell(C3)=calculate(C1, C2)
(in XlsxWriter format: ws.write(2, 2, '=calculate(C1,C2)))

I've looked at the unzipped excel file with VBA code, but I'm not sure how to integrate this.
Do you have any plan to support VBA code?

Thanks.

@jmcnamara jmcnamara self-assigned this May 28, 2014

@jmcnamara

This comment has been minimized.

Show comment
Hide comment
@jmcnamara

jmcnamara May 28, 2014

Owner

This is a planned feature, in an experimental mode, where a VBA project is extracted from an existing Excel file and added to a new XlsxWriter file.

This feature already exists in the Perl module from which XlsxWriter was ported.

However, as I said, it would be an experimental feature since it isn't effective 100% of the time.

I'll add it to the TODO list.

Owner

jmcnamara commented May 28, 2014

This is a planned feature, in an experimental mode, where a VBA project is extracted from an existing Excel file and added to a new XlsxWriter file.

This feature already exists in the Perl module from which XlsxWriter was ported.

However, as I said, it would be an experimental feature since it isn't effective 100% of the time.

I'll add it to the TODO list.

@jmcnamara

This comment has been minimized.

Show comment
Hide comment
@jmcnamara

jmcnamara Nov 6, 2014

Owner

Added in version 0.6.3, now on PyPI.

See the Working with VBA Macros section of the docs.

Best regards,

John

Owner

jmcnamara commented Nov 6, 2014

Added in version 0.6.3, now on PyPI.

See the Working with VBA Macros section of the docs.

Best regards,

John

@jmcnamara jmcnamara closed this Nov 6, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment