xlsx-to-markdown

Instructions

Implementation Reference

• src/tools.ts:111-124 (schema)

  Defines the input schema for the xlsx-to-markdown tool, requiring an absolute filepath.

  export const XlsxToMarkdownTool = ToolSchema.parse({
    name: "xlsx-to-markdown",
    description: "Convert an XLSX file to markdown",
    inputSchema: {
      type: "object",
      properties: {
        filepath: {
          type: "string",
          description: "Absolute path of the XLSX file to convert",
        },
      },
      required: ["filepath"],
    },
  });

• src/server.ts:31-35 (registration)

  Registers the xlsx-to-markdown tool (via XlsxToMarkdownTool schema) among others in the ListTools response.

  server.setRequestHandler(ListToolsRequestSchema, async () => {
    return {
      tools: Object.values(tools),
    };
  });

• src/server.ts:60-74 (handler)

  Dispatches execution for xlsx-to-markdown (and similar file converters): validates input filepath and invokes Markdownify.toMarkdown.

  case tools.PDFToMarkdownTool.name:
  case tools.ImageToMarkdownTool.name:
  case tools.AudioToMarkdownTool.name:
  case tools.DocxToMarkdownTool.name:
  case tools.XlsxToMarkdownTool.name:
  case tools.PptxToMarkdownTool.name:
    if (!validatedArgs.filepath) {
      throw new Error("File path is required for this tool");
    }
    result = await Markdownify.toMarkdown({
      filePath: validatedArgs.filepath,
      projectRoot: validatedArgs.projectRoot,
      uvPath: validatedArgs.uvPath || process.env.UV_PATH,
    });
    break;

• src/Markdownify.ts:51-92 (handler)

  Core implementation that converts XLSX files (via filepath) to markdown by invoking the markitdown executable and saving output to temp file.

  static async toMarkdown({
    filePath,
    url,
    projectRoot = path.resolve(__dirname, ".."),
    uvPath = "~/.local/bin/uv",
  }: {
    filePath?: string;
    url?: string;
    projectRoot?: string;
    uvPath?: string;
  }): Promise<MarkdownResult> {
    try {
      let inputPath: string;
      let isTemporary = false;
  
      if (url) {
        const response = await fetch(url);
        const content = await response.text();
        inputPath = await this.saveToTempFile(content);
        isTemporary = true;
      } else if (filePath) {
        inputPath = filePath;
      } else {
        throw new Error("Either filePath or url must be provided");
      }
  
      const text = await this._markitdown(inputPath, projectRoot, uvPath);
      const outputPath = await this.saveToTempFile(text);
  
      if (isTemporary) {
        fs.unlinkSync(inputPath);
      }
  
      return { path: outputPath, text };
    } catch (e: unknown) {
      if (e instanceof Error) {
        throw new Error(`Error processing to Markdown: ${e.message}`);
      } else {
        throw new Error("Error processing to Markdown: Unknown error occurred");
      }
    }
  }

• src/Markdownify.ts:19-40 (helper)

  Helper function that runs the markitdown executable on the XLSX file to generate markdown content.

  private static async _markitdown(
    filePath: string,
    projectRoot: string,
    uvPath: string,
  ): Promise<string> {
    const venvPath = path.join(projectRoot, ".venv");
    const markitdownPath = path.join(venvPath, "Scripts", "markitdown.exe");
  
    if (!fs.existsSync(markitdownPath)) {
      throw new Error("markitdown executable not found");
    }
  
    const { stdout, stderr } = await execAsync(
      `${venvPath}\\Scripts\\activate.bat && ${markitdownPath} "${filePath}"`,
    );
  
    if (stderr) {
      throw new Error(`Error executing command: ${stderr}`);
    }
  
    return stdout;
  }