Timeline for What commands can be issued to Excel for Mac from the terminal?
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 21, 2023 at 13:51 | comment | added | Dark Star1 | I would actually like to use excel to convert files from the old xls format to xlsx, but not the strict open format. Right now, I have to do them all by hand. I tried using LibreOffice but that converts to the strict open format which isn't what I need. I wouldn't like to script excel either but it's possibly "my only viable option" at this point. | |
| May 7, 2020 at 6:06 | answer | added | nohillside♦ | timeline score: 1 | |
| May 7, 2020 at 6:00 | history | edited | nohillside♦ | CC BY-SA 4.0 |
deleted 515 characters in body
|
| May 7, 2020 at 5:59 | history | reopened | nohillside♦ | ||
| May 6, 2020 at 23:36 | comment | added | Marc Wilson | While scripting Excel sounds... interesting, you've got the wrong solution. You want XLS files, that doesn't have to involve scripting the behemoth that is Excel. I think if I were going to do it script-ly, I'd use Numbers rather than Excel. But all you want to do is write XLS files. Python +XlsxWriter, maybe. | |
| May 6, 2020 at 21:47 | review | Reopen votes | |||
| May 7, 2020 at 6:05 | |||||
| May 6, 2020 at 21:29 | comment | added | 111936 | Have rearranged the question to clearly identify my question. --- And i see now that i will need to take the arp output into a txt file and then replace spaces with commas before handing that off to excel. I'm a novice, obviously, and am learning as I go. | |
| May 6, 2020 at 21:25 | history | edited | 111936 | CC BY-SA 4.0 |
Rearranged text to better identify main question.
|
| May 6, 2020 at 16:34 | comment | added | Marc Wilson | The sending commands from the terminal would be done with osascript. Excel's applescript dictionary isn't extensive, but it works. Your command 'arp -a | > newcsv.csv' would indeed create an empty file, as your syntax is incorrect. You don't pipe into a redirection operator. And I don't think you're going to get a reasonable CSV file without some pre-processing, probably through awk or sed. | |
| May 6, 2020 at 11:16 | history | closed | nohillside♦ | Needs more focus | |
| May 6, 2020 at 11:16 | comment | added | nohillside♦ |
There currently seem at least three questions in your post: How can I catch the output of arp -a in a form useable by Excel, how can I launch Excel from Terminal with this and how can I send commands from Terminal to Excel. So can you edit your question to focus on the main objective here?
|
|
| May 6, 2020 at 9:04 | comment | added | 111936 | Had not, but when I just did it opened a blank workbook. And I got this repeating in terminal: 'Microsoft Excel[98574:4719817] Stream 0x7fcee5f60e30 is sending an event before being opened' and terminal is stuck (no prompt) | |
| May 6, 2020 at 7:19 | comment | added | anki |
did you try /Applications/Microsoft\ Excel.app/Contents/MacOS/Microsoft\ Excel --help ?
|
|
| May 6, 2020 at 7:07 | review | First posts | |||
| May 6, 2020 at 11:04 | |||||
| May 6, 2020 at 7:02 | history | asked | 111936 | CC BY-SA 4.0 |