Repository: frictionlessdata/framework
Issue: Reading resource data from excel throws source error

# Overview

I have a data package [hosted on github](https://github.com/splor-mg/datapackage-reprex/tree/main/20230512T084359) which has a resource with data in excel. When I try to read it's data

```python
from frictionless import Package

package = Package('https://raw.githubusercontent.com/splor-mg/datapackage-reprex/main/20230512T084359/datapackage.json')

package.get_resource('excel').read_rows()
```

I get the following error

```
Traceback (most recent call last):
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/system/parser.py", line 195, in __next__
    return self.cell_stream.__next__()  # type: ignore
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/formats/excel/parsers/xlsx.py", line 125, in read_cell_stream_create
    stat = os.stat(self.resource.normpath)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
FileNotFoundError: [Errno 2] No such file or directory: 'https://raw.githubusercontent.com/splor-mg/datapackage-reprex/main/20230512T084359/missing_date.xlsx'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/resources/table.py", line 417, in read_rows
    with helpers.ensure_open(self):
  File "/Users/fjunior/.pyenv/versions/3.11.2/lib/python3.11/contextlib.py", line 137, in __enter__
    return next(self.gen)
           ^^^^^^^^^^^^^^
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/helpers.py", line 127, in ensure_open
    thing.open()
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/resources/table.py", line 165, in open
    self.__open_parser()
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/resources/table.py", line 182, in __open_parser
    self.__parser.open()
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/system/parser.py", line 94, in open
    self.__cell_stream = self.read_cell_stream()
                         ^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/system/parser.py", line 135, in read_cell_stream
    for cells in cell_stream:
  File "/Users/fjunior/Projects/datapackage-reprex/20230512T084359/venv/lib/python3.11/site-packages/frictionless/system/parser.py", line 208, in __next__
    raise FrictionlessException(error) from exception
frictionless.exception.FrictionlessException: [source-error] The data source has not supported or has inconsistent contents: [Errno 2] No such file or directory: 'https://raw.githubusercontent.com/splor-mg/datapackage-reprex/main/20230512T084359/missing_date.xlsx'
```

The error message is misleading because the file `https://raw.githubusercontent.com/splor-mg/datapackage-reprex/main/20230512T084359/missing_date.xlsx`exists. 

If I download the [package](https://github.com/splor-mg/datapackage-reprex/tree/main/20230512T084359) locally I can read from the excel file just fine:

```python
>>> from frictionless import Package
>>> package = Package('datapackage.json')
>>> package.get_resource('excel').read_rows()
[{'id': 1, 'updated_at': datetime.date(2023, 1, 31)}, {'id': 2, 'updated_at': None}, {'id': 3, 'updated_at': datetime.date(2023, 1, 31)}, {'id': 4, 'updated_at': datetime.date(2023, 3, 9)}]
```

I'm using frictionless 5.13.1 (on an M1 Mac).

Changed files:
tests/portals/zenodo/test_adapter.py, frictionless/schemes/remote/loader.py

diff --git a/frictionless/schemes/remote/loader.py b/frictionless/schemes/remote/loader.py
index 0de9647d..96a01d23 100644
--- a/frictionless/schemes/remote/loader.py
+++ b/frictionless/schemes/remote/loader.py
@@ -1,6 +1,7 @@
 from __future__ import annotations
 import io
 from typing import TYPE_CHECKING, Optional
+from frictionless import helpers
 from .control import RemoteControl
 from ...platform import platform
 from ...system import system, Loader
@@ -29,6 +30,7 @@ class RemoteLoader(Loader):
             buffer.write(byte_stream.read())
             buffer.seek(0)
             byte_stream = buffer
+        self.resource.scheme, _ = helpers.parse_scheme_and_format(self.resource.normpath)
         return byte_stream
 
     # Write
diff --git a/tests/portals/zenodo/test_adapter.py b/tests/portals/zenodo/test_adapter.py
index 45931827..eb820608 100644
--- a/tests/portals/zenodo/test_adapter.py
+++ b/tests/portals/zenodo/test_adapter.py
@@ -11,7 +11,7 @@ PACKAGE_WITHOUT_DP = {
             "name": "capitals",
             "type": "table",
             "path": "capitals.csv",
-            "scheme": "file",
+            "scheme": "https",
             "format": "csv",
             "encoding": "utf-8",
             "mediatype": "text/csv",
@@ -28,7 +28,7 @@ PACKAGE_WITHOUT_DP = {
             "name": "table",
             "type": "table",
             "path": "table.xls",
-            "scheme": "file",
+            "scheme": "https",
             "format": "xls",
             "encoding": "utf-8",
             "mediatype": "application/vnd.ms-excel",
@@ -196,7 +196,7 @@ def test_zenodo_adapter_read_record_only_csv(options_with_dp_multiple_files_with
                 "name": "capitals",
                 "type": "table",
                 "path": "capitals.csv",
-                "scheme": "file",
+                "scheme": "https",
                 "format": "csv",
                 "encoding": "utf-8",
                 "mediatype": "text/csv",