Commit Graph

79 Commits

Author SHA1 Message Date
Bobby Abellana
69d132300d Made GUI Changes 2025-02-24 15:27:25 -08:00
Bobby Abellana
38f5793883 ExcelFileHandling 2025-02-24 15:04:58 -08:00
Bobby Abellana
3b74aba8ed Updated Readme 2025-02-24 14:57:02 -08:00
Bobby Abellana
b45a6c490a Created README.md 2025-02-24 14:47:52 -08:00
Bobby Abellana
eb0f2299d3 Removed recurisve 2025-02-24 14:39:31 -08:00
Bobby Abellana
7822f074c4 ConvertsXLStoXLSX and save to original location 2025-02-24 14:37:47 -08:00
Bobby Abellana
e29391639f Saving Converted Files in Temp Library with same folder structure 2025-02-24 14:13:17 -08:00
Bobby Abellana
d729b88606 cursor update 2025-02-21 15:34:46 -08:00
Bobby Abellana (aider)
ffbe44da0a fix: Add error handling for Excel SaveAs operation in Convert-Files function 2025-02-21 11:30:09 -08:00
Bobby Abellana (aider)
e615e043e3 refactor: Replace Excel Interop enum with numeric constant in SaveAs 2025-02-21 11:27:23 -08:00
Bobby Abellana (aider)
64540f9a0e refactor: Simplify Excel file conversion by removing temporary file handling 2025-02-21 11:26:00 -08:00
Bobby Abellana (aider)
ff2500707f fix: Improve Excel file conversion with temp files and better cleanup 2025-02-21 11:24:11 -08:00
Bobby Abellana (aider)
b725f52366 fix: Correct temp library path construction and remove duplicate upload 2025-02-21 11:14:46 -08:00
Bobby Abellana (aider)
93ffe6a5a2 refactor: Simplify Excel conversion process in SharePointFunctions.ps1 2025-02-21 11:11:37 -08:00
Bobby Abellana (aider)
31407f0330 fix: Improve Excel file handling with temporary paths and better cleanup 2025-02-21 11:09:47 -08:00
Bobby Abellana (aider)
2077423bc0 refactor: Replace Import-Module with dot-sourcing in PowerShell scripts 2025-02-21 11:07:58 -08:00
Bobby Abellana (aider)
b8049f6f85 refactor: Replace SaveAs2 with standard SaveAs method in Excel conversion 2025-02-21 11:03:55 -08:00
Bobby Abellana (aider)
cc887b4d3e fix: Improve Excel file conversion with SaveAs2 and robust path handling 2025-02-21 11:02:24 -08:00
Bobby Abellana (aider)
b55058161a fix: handle file paths with spaces and special characters in Excel conversion 2025-02-21 11:00:28 -08:00
Bobby Abellana (aider)
dfb9dc3557 fix: handle spaces in Excel SaveAs paths and add file verification 2025-02-21 10:58:34 -08:00
Bobby Abellana (aider)
c6c0769384 fix: Use -OutputFilePath for binary downloads in Convert-Files 2025-02-21 10:56:30 -08:00
Bobby Abellana (aider)
065a822866 fix: Correct file download method in Convert-Files function 2025-02-21 10:54:58 -08:00
Bobby Abellana (aider)
83895edac4 fix: Correct URI construction and ensure proper function exports/imports 2025-02-21 10:53:22 -08:00
Bobby Abellana (aider)
529c0f3982 fix: Update SharePoint file download/upload to use proper drive ID 2025-02-21 10:52:05 -08:00
Bobby Abellana (aider)
728ce14af4 fix: Properly escape URI and improve Load-Config error message 2025-02-21 10:49:18 -08:00
Bobby Abellana (aider)
3a2cb289db refactor: Improve Excel COM object handling with try-finally and GC cleanup 2025-02-21 10:47:07 -08:00
Bobby Abellana (aider)
a5057f2a0d refactor: Remove OpenXML dependency and improve Excel COM cleanup 2025-02-21 10:46:42 -08:00
Bobby Abellana (aider)
01a86be2a1 fix: improve OpenXML installation with proper path handling and error checking 2025-02-21 10:42:19 -08:00
Bobby Abellana (aider)
276c1a615d fix: Update TLS protocol and OpenXML installation via NuGet 2025-02-21 10:39:05 -08:00
Bobby Abellana (aider)
783314d3a7 fix: escape variables in Install-Dependencies.ps1 error messages 2025-02-21 10:33:12 -08:00
Bobby Abellana (aider)
8384c27b04 fix: Correct error message formatting in Install-Dependencies.ps1 2025-02-21 10:30:00 -08:00
Bobby Abellana (aider)
102b25d972 fix: Correct variable reference in error message for OpenXml module installation 2025-02-21 10:29:17 -08:00
Bobby Abellana (aider)
be054b19c8 fix: Use ${_} for proper variable interpolation in error messages 2025-02-21 10:28:31 -08:00
Bobby Abellana (aider)
3859fb5c1f feat: Add Microsoft Graph and OpenXml module installation to Install-Dependencies.ps1 2025-02-21 10:27:52 -08:00
Bobby Abellana (aider)
03b58af4ea fix: Improve assembly loading with GAC fallback in MainForm.ps1 2025-02-21 10:23:29 -08:00
Bobby Abellana (aider)
eb6c9adc6b feat: Implement file conversion logic using DocumentFormat.OpenXml 2025-02-21 10:21:17 -08:00
Bobby Abellana (aider)
fe308bc16f feat: Add placeholder Convert-Files function to SharePointFunctions.ps1 2025-02-21 10:16:42 -08:00
Bobby Abellana (aider)
f1e3a09cc0 feat: Add recursive listing checkbox to MainForm 2025-02-21 10:13:39 -08:00
Bobby Abellana (aider)
2c18235425 refactor: Reposition status textbox and add DataGridView in MainForm.ps1 2025-02-21 10:02:34 -08:00
Bobby Abellana (aider)
aed44fc07d fix: Check folder and child count before recursing in Get-XlsFilesRecursive 2025-02-21 09:50:07 -08:00
Bobby Abellana (aider)
6bda577ba3 feat: Add newlines to status text for file listing 2025-02-21 09:46:16 -08:00
Bobby Abellana (aider)
c70add19f6 feat: Make textbox resize with form using AutoScaleMode and Anchor 2025-02-21 09:43:52 -08:00
Bobby Abellana (aider)
bbf46c9eb8 fix: Add null checks and error handling in Get-XlsFilesRecursive 2025-02-21 09:42:26 -08:00
Bobby Abellana (aider)
cc799c7d68 feat: Add recursive search for XLS files in subfolders 2025-02-21 09:39:39 -08:00
Bobby Abellana (aider)
004a3d239e feat: Add Load-Config and Save-Config functions to SharePointFunctions.ps1 2025-02-21 09:36:15 -08:00
Bobby Abellana (aider)
b6c9a15a15 feat: Add "Select Folder" button to folder browser dialog 2025-02-21 09:34:43 -08:00
Bobby Abellana (aider)
7fb87bdccf fix: Correct URL encoding for folder paths with spaces 2025-02-21 09:32:38 -08:00
Bobby Abellana (aider)
c30d7ccdc5 refactor: Replace Out-GridView with Form and ListBox in Get-FolderBrowser 2025-02-21 09:30:59 -08:00
Bobby Abellana (aider)
37ec5d328e feat: Add subfolder browsing to Get-FolderBrowser function 2025-02-21 09:28:26 -08:00
Bobby Abellana (aider)
5194dc0198 fix: URL encode folder path in List-XlsFiles function 2025-02-21 09:26:32 -08:00