----------------------
I'm sorry, but based on the information provided in the knowledge sources, there's no explicit mention of the ability to read formulas from Excel files using the
PandasExcelReader
class in LlamaIndex. The
PandasExcelReader
class uses the
read_excel
function from the pandas library to parse Excel files, and this function typically reads the values of cells, not the formulas.
However, you might be able to achieve this by using the
read_excel
function with specific parameters. You would need to refer to the pandas documentation for more details on this.
Here is the basic usage of the
PandasExcelReader
class:
class PandasExcelReader(BaseReader):
def __init__(
self,
*args: Any,
concat_rows: bool = True,
sheet_name=None,
pandas_config: dict = {},
**kwargs: Any
) -> None:
super().__init__(*args, **kwargs)
self._concat_rows = concat_rows
self._sheet_name = sheet_name
self._pandas_config = pandas_config
You can find more details about the
PandasExcelReader
class in the
LlamaIndex documentation ().
For more advanced usage or specific needs, you might need to extend the
PandasExcelReader
class or create a custom reader.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------