Skip to content
This repository has been archived by the owner on Sep 1, 2022. It is now read-only.

Command line interface #56

Open
mattpalermo opened this issue Feb 21, 2017 · 3 comments
Open

Command line interface #56

mattpalermo opened this issue Feb 21, 2017 · 3 comments

Comments

@mattpalermo
Copy link
Collaborator

A command line interface for CodeExport could be useful to build and open a workbook straight from the command line with a few keystrokes. For example, in your working directory, you may be able to type a command:

xlbuild MyWorkbook.xlsm

which would open the workbook and run the CodeExport import command. This would allows for a much faster workflow, especially if there is actions that need to be taken before opening and after closing MyWorkbook.xlsm. This will be crucial for implementing issue #55 and the OoXmlUnpack functionality since these functions will (may) operate on the MyWorkbook.xlsm before and after Excel has opened it.

@spences10
Copy link
Owner

I'm currently looking at:

  1. Change file extension
  2. Save as .zip
  3. Unzip file
  4. make unicorns!
  5. Zip
  6. Re-packed Excel with ribbon UI

I found this ribboneditor that generates the XML you need to create a ribbon item

Is this CLI going to circumvent this work? I have done steps 1-3 currently

@mattpalermo
Copy link
Collaborator Author

I'm currently looking at:

...

Nice, I look forward to it seeing how it goes.

I found this ribboneditor that generates the XML you need to create a ribbon item

Nice, seems like a convenient way to generate the xml.

Is this CLI going to circumvent this work? I have done steps 1-3 currently

I imagine the CLI to serve a few different purposes. In many cases it will simply be another 'interface' from which the existing CodeExport functionality will be called. So, as long as your solution solves its target problem in a user friendly way, I don't think there is a problem.

I am curious about how you are going to achieve step 4 (make unicorns). Are you going to modify the XML itself or are you going to use a library to achieve this?

@mattpalermo
Copy link
Collaborator Author

It seems your current work will help with issues #57 and #55.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants