Doug Finke
5387c06146
Merge pull request #1695 from scriptingstudio/master
...
[Get-HtmlTable] XPath optimization
2025-04-23 08:16:05 -04:00
Matthew Gray
45ed6a06dc
[Get-HtmlTable] XPath optimization
...
```powershell
$rows = $h.SelectNodes("//table[$TableIndex]//tr")
```
XPath selector in line 53 uses complex expression that can lead to unexpected result. The problem is that HtmlAgilityPack may have specific issues. In particular, on websites containing multiple tables this selector can find not one table. This is aggravated by the fact that tables can have different structures.
To avoid ambiguity this PR suggests to separate queries. Oneliner simplifies error checking
```powershell
$rows = try {
$h.SelectSingleNode("//table[$TableIndex]").SelectNodes(".//tr")
} catch {}
if (-not $rows) {Write-Warning "Could not find rows for `"//table[$TableIndex]`" in $Url ."}
```
This expression doesn't even need testing, it just works.
2025-04-23 13:36:32 +03:00
dfinke
fa447a745c
move llms text to root
2025-04-11 07:10:31 -04:00
dfinke
49affcfba7
add llms text of Examples directort for use in LLMs
2025-04-11 06:51:18 -04:00
dfinke
dc4a5e9db9
chore: Update changelog for version 7.8.10 and acknowledge PR contributions
2024-10-21 19:44:36 -04:00
Doug Finke
85e48acf36
Merge pull request #1648 from evenmartinsen/master
...
Remove flagged URL
2024-10-21 19:42:23 -04:00
dfinke
fb41d3de83
chore: Update module version to 7.8.10
2024-10-21 19:39:44 -04:00
dfinke
db84a59dd0
chore: Update module version to 7.8.10
2024-10-21 19:37:58 -04:00
Even Martinsen
5a61c5dda4
Re-add icon variable (Commented)
...
re-added variable for easier modification in the future.
2024-10-21 14:37:55 +02:00
Even Martinsen
a2bc50aeb0
Remove flagged URI
...
Removed due to various AV's flagging the link as malicious thus flagging and quarentining the module.
2024-10-21 14:35:50 +02:00
dfinke
fa907da4a4
chore: Update module version to 7.8.9
2024-05-18 09:41:57 -04:00
dfinke
24c205e65d
feat: Improve ConvertTo-ExcelXlsx robustness
...
This commit improves the `ConvertTo-ExcelXlsx` function by making it more robust. Thanks to Edward Miller for the contribution.
Note: This message follows the established convention of starting with a type (feat for feature) and providing a concise and clear description of the changes made.
2024-05-18 09:41:50 -04:00
Doug Finke
a1418a336e
Merge pull request #1603 from edwardmiller-mesirow/read-only
...
[ConvertTo-ExcelXlsx] open XLS as read-only
2024-05-18 09:37:38 -04:00
dfinke
63683db543
chore: Update module version to 7.8.8
2024-05-18 09:33:54 -04:00
Edward Miller
36b5495bd5
check for null first
2024-05-17 23:28:26 -05:00
Edward Miller
722516de7c
use try-finally
2024-05-17 23:24:11 -05:00
Edward Miller
57bb049111
open XLS as read-only
2024-05-17 22:41:53 -05:00
Doug Finke
74cbca8b2f
Merge pull request #1591 from pbossman/master
...
Resolve worksheet ArgumentCompleter Fixes:#1590
2024-05-03 13:50:52 -04:00
Doug Finke
53712d4f7f
bump version
2024-05-03 13:46:19 -04:00
Doug Finke
98e2ac96ea
update changelog and add image
2024-05-03 13:46:02 -04:00
Phil Bossman
efa73b37a0
Resolve worksheet argumentcompleter Fixes:#1590
2024-04-30 11:59:08 -04:00
Doug Finke
c1b395fac6
Merge pull request #1578 from RipFence/ChartDataSeparateBranch
...
ChartDataSeparatePage.ps1
2024-03-15 08:24:32 -04:00
dfinke
0d8d125222
Add infrastructure change and new features
2024-03-15 08:21:17 -04:00
dfinke
f77ee7b060
Ignore Examples folder in CI workflow
2024-03-15 08:21:07 -04:00
Tim Kremer
8ff1757c06
ChartDataSeparatePage.ps1
2024-03-14 13:33:49 -05:00
dfinke
ab526558a3
more badges
2023-12-27 16:00:40 -05:00
Doug Finke
61744012cd
Merge pull request #1522 from kyllath/master
...
Add missing parameter aliases to align with caller/callee
2023-10-12 17:16:46 -04:00
dfinke
2cb4712bc5
bump version
2023-10-12 17:10:00 -04:00
dfinke
6847a49baa
update log
2023-10-12 17:09:56 -04:00
John Boyne
b8a8f4c565
Add missing parameter aliases to align with caller/callee
2023-10-11 20:36:26 +01:00
Doug Finke
edf25cf946
Merge pull request #1465 from dfinke/Extend-Get-Excel-File-Summary
...
Add Get-ExcelFileSchema
2023-06-14 05:54:11 -04:00
dfinke
77ec946b84
update changelog
2023-06-14 05:45:57 -04:00
dfinke
637c11c2e6
needs to work xplat
2023-06-10 16:40:25 -04:00
dfinke
cd2a70197c
use -BeExactly
2023-06-10 16:00:11 -04:00
dfinke
d99bd8fc9e
add tests
2023-06-10 15:45:35 -04:00
dfinke
23f1d92c1b
first pass
2023-06-10 15:27:53 -04:00
Doug Finke
ab4d03c984
Merge pull request #1392 from stahler/patch-7
...
minor spelling edit
2023-02-05 06:41:07 -05:00
Doug Finke
ca4dfb7040
Merge pull request #1391 from stahler/patch-6
...
minor syntax changes
2023-02-05 06:40:54 -05:00
Wes Stahler
a9eca05303
minor spelling edit
2023-02-04 22:16:22 -05:00
Wes Stahler
195efdea54
minor syntax changes
2023-02-04 22:04:08 -05:00
Doug Finke
24e5fccafe
Merge pull request #1361 from dfinke/thkn-hofa-Issue1344
...
Fix Issue 1344 with Freeze Top Row
2022-12-28 15:58:09 -05:00
dfinke
840870df11
Resolve conflict
2022-12-28 14:26:43 -05:00
dfinke
0fe6654233
Add additional test
2022-12-28 14:16:14 -05:00
dfinke
7598b75538
update
2022-12-27 16:20:50 -05:00
Doug Finke
ed6c87e8de
Merge pull request #1357 from thkn-hofa/Issue1316
...
Add -NoHyperLinkConversion
2022-12-27 16:11:17 -05:00
dfinke
2642211e12
Added some hyperlink tests
2022-12-27 16:06:07 -05:00
Thomas Hofkens
9373765e10
Introduced tests for Freezing panes
2022-12-26 13:10:24 +01:00
Thomas Hofkens
16820a30c4
Add -NoHyperLinkConversion
2022-12-26 01:22:22 +01:00
Thomas Hofkens
438d7e2b03
Fix Issue 1344
2022-12-25 23:44:21 +01:00
dfinke
c617d96322
Tweak both
2022-12-11 10:26:47 -05:00
