Skip to main content
Share Your Experience: Take the 2024 Developer Survey
11 votes
Accepted

Install ssconvert (part of gnumeric) on a server without GNOME

I think many of the dependencies for gnumeric are actually "recommended" packages, not real dependencies. Try this: sudo apt-get install --no-install-recommends gnumeric For me, this installed about ...
Ian Phillips's user avatar
4 votes

Subnet calculator for MS Excel

The following function (that calls Marcus Mansfield's IPSubnetCalc) will output a network range when given a subnet: Public Function IPRange(IPandMaskInput$) ' PROGRAM: ' IP Range ...
Tomáš Pospíšek's user avatar
3 votes

Convert lscpu output to row based format in excel/csv table format

Use JSON format and register the data to the variable lscpu_out - command: lscpu -J register: lscpu_out Extract all variables lscpu_out, get the attribute stdout, convert the strings to ...
Vladimir Botka's user avatar
3 votes

Convert lscpu output to row based format in excel/csv table format

You can print the output of lscpu in JSON format, then select what you need with jq: [user@laptop ~]$ lscpu -J|jq .lscpu[0] { "field": "Architecture:", "data": "...
Mircea Vutcovici's user avatar
2 votes

Powrshell Script to read the Windows Secutiry logs and filter Elevation type 196 and 1937

have you tried something like this : Get-EventLog -logname security | Where-Object {($_.eventid -eq 1936) -or ($_.eventid -eq 1937) -or ($_.eventid -eq 1938)} | export-csv -path c:\temp\events
Sorcha's user avatar
  • 1,345
2 votes

Prevent Office apps from saving to OneDrive by default

For your question; Prevent Office apps from saving to OneDrive by default Those do the trick to prevent that; HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\Common\General ...
yagmoth555's user avatar
  • 17.2k
1 vote

Performance Issues for Excel Relinking in Powershell

Have a look at the ImportExcel module. It can import and export data from Excel directly so it is a lot quicker and reliable than using COM objects.
smwk's user avatar
  • 580
1 vote
Accepted

Best way to convert azure logs date time into an excel date time

All Azure log dates are in UTC. Take a look at: https://stackoverflow.com/questions/36456115/excel-how-to-convert-utc-date-time =--SUBSTITUTE(LEFT(A1,FIND("Z",A1)-1),"T"," &...
Ken W - Zero Networks's user avatar
1 vote
Accepted

Why does writing to a workbook of a few MB with Python's openpyxl module eat Gigabytes of RAM?

That openpyxl requires a lot of RAM for reading/writing Excel files is known: According to the openpyxl documentation about performance the general RAM usage can be calculated this way. Memory use ...
Robert's user avatar
  • 221
1 vote

Signing Excel .XLSM-documents, expiring code signing certificates and trusted publishers

You need to use a timestamp when you sign the macros. That way, as long as you signed them when the certificate was valid, they will still be able to run after the certificate expires. (Unless the ...
John C. Kirk's user avatar
1 vote

Is there any solution out there that is as easy to use as power query but handles 2gb of data?

For the kind of scenario you are describing I would like to recommend you Big Query, this is a fully managed service focused on work and process with big loads of data and has different use cases for ...
Harif Velarde's user avatar
1 vote

Can not run EXCEL.EXE with “runas”, it says: “1312: A specified logon session does not exist. It may already have been terminated.”

I reported that issue to Microsoft and, after raising up few levels, they have worked on it and fixed. It's fixed on Windows 10 Build 19042.844
forlayo's user avatar
  • 121
1 vote

Active directory from VBA Excel 2016

dsquery is part of an optional feature on Windows workstation. There are also much better ways of doing this than using dsquery.
Greg Askew's user avatar
  • 37.1k
1 vote

Prevent Office apps from saving to OneDrive by default

Please refer to this similar thread: https://social.technet.microsoft.com/Forums/office/en-US/3a30e1c3-ed3c-458a-b3f3-b36b2be9766f/file-save-locations-office-365?forum=Office2016ITPro then you can ...
Bella 's user avatar
  • 121
1 vote

Passing AD identity from Sharepoint Online to Analysis Services Tabular on an Azure VM

Within SharePoint Online, you can't connect to SSAS data sources within Excel web apps, when the workbook is uploaded to the document library. You can however, view static data. To upload workbooks ...
Jsmith_iii's user avatar
1 vote

No 'locked for editing' message for an Excel file on a network share

There's a possible answer at: https://helpdesk.yourofficeanywhere.co.uk/kb/a183/excel-loses-file-locked-for-editing-when-accessing-data-on-network-drive-mapped-via-group-policy.aspx In summary: If ...
Nigel Hawkins's user avatar
1 vote

Install ssconvert (part of gnumeric) on a server without GNOME

Further to the answer from @IanPhillips: sudo apt-get install --no-install-recommends gnumeric I've just tried this on a clean headless Ubuntu 20.04 server VM. apt claimed it would be a 115MB install;...
EML's user avatar
  • 470
1 vote

Install ssconvert (part of gnumeric) on a server without GNOME

You can also use in2csv of package csvkit. https://csvkit.readthedocs.io/en/1.0.2/
Isa Nazhmudinov's user avatar
1 vote

Corrupt Excel Files After Setting Up User Profiles, Folder Redirection & Offline Files

We had the same issue when we moved over to roaming profiles, though it was only for protected Excel files i believe. The Office Trust Center was reading shared files on the network as originating ...
mike harkleroad's user avatar
1 vote

Weird bug when copying from sql server management studio to excel in windows 7

I know this is a very old question but i happened to run into the same issue just now and it was because of the " character. I just removed that in my query with a replace syntax and it worked. PS i ...
user2181585's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible