How to extract Image from Excel #1962

2022-01-27T09:46:13Z

this is my Excel data:

I want to extract images from the Excel. But I read undefind.

I want to know how to extract images from Excel, thank you.

2022-02-01T17:00:06Z

@HuoXiaoYe

假设图片在单元格A1,想要获得图片的信息,示例代码如下:

const cell = worksheet.getCell('A1');

如果你想获取某个worksheet下所有的图片,示例代码如下:

const images: Array<{
  type: 'image',
  imageId: string;
  range: ImageRange;
}> = worksheet.getImages();

for (const image of images) {
  const img: Image = workbook.getImage(+image.imageId);
}

2022-02-10T13:45:37Z

@skypesky 同学你好，我发现用getCell('A1')这种方法获取的是一个空值，即便A1单元格是有一张图片的。

2022-02-10T13:46:42Z

@skypesky worksheet.getImages();这种方式我可以获取到一个sheet中的所有图片，但是imageID 和我在sheet中出现的顺序是对应不上的。所以貌似也不太行😂

2022-02-10T13:50:28Z

@HuoXiaoYe 你做测试的excel可以提供一下吗?

2022-02-10T15:34:12Z

@HuoXiaoYe
这个回答可以解决你的问题.

HuoXiaoYe closed this as completed Feb 10, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

How to extract Image from Excel #1962

How to extract Image from Excel #1962

HuoXiaoYe commented Jan 27, 2022

skypesky commented Feb 1, 2022 •

edited

HuoXiaoYe commented Feb 10, 2022

HuoXiaoYe commented Feb 10, 2022

skypesky commented Feb 10, 2022

skypesky commented Feb 10, 2022

How to extract Image from Excel #1962

How to extract Image from Excel #1962

Comments

HuoXiaoYe commented Jan 27, 2022

skypesky commented Feb 1, 2022 • edited

假设图片在单元格A1,想要获得图片的信息,示例代码如下:

如果你想获取某个worksheet下所有的图片,示例代码如下:

HuoXiaoYe commented Feb 10, 2022

HuoXiaoYe commented Feb 10, 2022

skypesky commented Feb 10, 2022

skypesky commented Feb 10, 2022

skypesky commented Feb 1, 2022 •

edited