|
- Create a new template in 'List My Apps' -app's Template Editor by clicking Options (three dots) → Template Editor → Add. [Screenshot]
- Type in a name for the template.
- Paste all the appropriate template data (the three sections as specified below) to 'List My Apps'. Please include one empty row after "File Header" and "Body" (so that the script will write each app on its own row instead of all apps in one row) and save the template.
- After saving the template go back to the 'List My Apps' -app's home screen and select the name that was created in Step 2 from the 'Copy/Share as:' -dropdown menu. Please also select the apps that you'd like to be included in the list. [Screenshot]
- 'Run' the 'List My Apps' -app with the new template by copying the app data to Clipboard [Copy] (since direct sharing may not work, if a lot of applications has been installed).
- There seems to be some kind of a limit, how much data the Android Clipboard can contain. With verbose templates ~200 apps might be the upper limit, but with a simple template, the Android Clipboard clearly is capable of containing considerably more app data.
- Open a text editor, such as DroidEdit Free.
- Paste the app data (source code generated by 'List My Apps' in Step 5) from Clipboard to the text editor.
- If nothing happens (no data is pasted to a text editor after a few seconds), try selecting fewer apps in 'List My Apps' and go back to Step 5.
- Depending on the device some lagging may occur when trying to paste, say ~10000 lines of code.
- If "old data" gets pasted to a text editor (i.e. "the data that was in the Clipboard before List My Apps' 'Copy to Clipboard' -button was clicked"), try selecting fewer apps in 'List My Apps' and go back to Step 5.
- Save the file as a .txt-file, for example as 'Installed_Apps.txt', for example in 'Home/Documents' folder (a filename without any spaces is recommended).
- Copy the .txt-file to, for instance,
C:\Temp\ -directory in Windows.
- Microsoft Excel (Text Import Wizard)
- On the Data tab of the Ribbon bar, in the Get External Data group, click From Text. Then, in the Import Text File dialog box, double-click the Installed_Apps.txt file.
- Step 1 of 3: Set the original data type as Delimited, Start import at row 1 and the choose a character set in File origin, which matches the character set in Step 8 (In most cases, the File origin -setting can be left at its default). Click Next.
- Step 2 of 3. Select semi-colon under Delimiters and make sure all other options are NOT selected, and also that Text qualifier is set to " and click Next.
- Step 3 of 3: The Column data format can be set individually for each column. The default General setting works fine for most of the fields, but at least the 'Version' column has to be set to Text in order to preserve the original data during the import. Click Finish.
- Select where the imported cells are placed and click OK.
- LibreOffice Calc Paste Special via Windows Notepad
- After copying the .txt-file to, for instance,
C:\Temp\ -directory in Windows (Step 9) open the .txt-file in Windows Notepad, select all text (Ctrl + A) and copy the selection to Windows Clipboard (Ctrl + C).
- Open LibreOffice Calc and click Edit → Paste Special (Ctrl + Shift + V) and double-click Unformatted Text.
- Paste Special can also be found as an icon in the toolbar or by right-clicking a cell.
- Set semi-colon as the Delimiter and make sure all other options are NOT selected, and also that Text qualifier is set to " and start import at row 1 and choose a character set, which matches the character set set in Step 8 (In most cases, the Character set -setting can be left at its default). Click OK.
- In Excel this procedure can be initiated by clicking the text "Paste" below the paste icon in Home tab of the Ribbon bar and selecting Use Text Import Wizard.
- Windows PowerShell
- After copying the .txt-file to, for instance,
C:\Temp\ -directory in Windows (Step 9) open Windows PowerShell. Type the script below and press [Enter] (to convert the .txt-file into a .csv-file with semi-colon as delimiter):
Import-Csv C:\Temp\Installed_Apps.txt -Delimiter ";" | sort Type,Name | Export-Csv C:\Temp\csvfile.csv -Delimiter ";" -NoTypeInformation -Encoding UTF8
- Parameters:
sort |
Sorting can be adjusted to one's liking by adjusting "sort Type,Name" with approppriate column header names (which are set in the "File Header:" -section). |
-Delimiter |
Any single character can be used as a delimiter in the exported CSV-file. For tab character as a delimiter, the two character 't -combo might work. |
-NoTypeInformation |
Without the the NoTypeInformation-parameter the first line of the CSV-file would contain #TYPE followed by the name of the type of the object, and that is not a desired effect here. |
-Encoding |
The default value is ASCII. The acceptable values for this parameter are:
Unicode |
UTF7 |
UTF8 |
ASCII |
UTF32 |
BigEndianUnicode |
Default |
|
-Force |
If any error messages are detected and you know your're right, use the Force. |
-NoClobber |
Halts the procedure, if overwriting (replacing the contents) of an existing file is about to happen. By default, if a file exists in the specified path, Export-Csv overwrites the file without warning. |
-Confirm |
Prompts you for confirmation before running the cmdlet. |
- Further info: https://technet.microsoft.com/en-us/library/hh849932.aspx
- Conversion from CSV to .xlsx or .ods should be pretty straightforward with Office apps, such as Microsoft Excel or LibreOffice. A couple of extra Windows PowerShell scripts below:
- CSV to Excel (in Windows PowerShell)
$xl = new-object -comobject excel.application |
$xl.visible = $False |
$Workbook = $xl.workbooks.open("C:\Temp\csvfile.csv") |
$Worksheets = $Workbooks.worksheets |
$Workbook.SaveAs("C:\Temp\Excelfile.xlsx",1) |
$Workbook.Saved = $True |
$xl.Quit() |
- Excel to CSV (in Windows PowerShell)
$xlCSV = 6 |
$Excel = New-Object -Com Excel.Application |
$Excel.visible = $False |
$Excel.displayalerts=$False |
$WorkBook = $Excel.Workbooks.Open("C:\Temp\Excelfile.xlsx") |
$Workbook.SaveAs("C:\Temp\process.csv",$xlCSV) |
$Excel.quit() |
- Export-XLXS.ps1 (in Windows PowerShell)
| First: |
. .\Export-XLXS.ps1 |
| Then: |
Get-Command -CommandType Function -Name Export-XLXS |
| That gave: |
CommandType Name Version Source
----------- ---- ------- ------
Function Export-XLXS |
| Then: |
Get-Process | select Name,Id,Handles | Export-XLXS C:\Temp\report.xlsx |
- ConvertCSV-ToExcel.ps1 (in Windows PowerShell)
| First: |
. .\ConvertCSV-ToExcel.ps1 |
| Then: |
Get-Command -CommandType Function -Name ConvertCSV-ToExcel |
| That gave: |
CommandType Name Version Source
----------- ---- ------- ------
Function ConvertCSV-ToExcel |
| Then: |
ConvertCSV-ToExcel -inputfile 'csvfile.csv' -output 'Excelfile.xlsx' |
|
