Winform中实现Excel导入、表格展示、多选获取值、生成二维码、打印流程(附代码下载)

素颜马尾好姑娘i 2024-04-17 18:22 21阅读 0赞

## 场景 ##

### 整体流程需求 ###

1.导入Excel并获取Excel的数。。

2.将Excel的数据复制给DataGridView中进行显示并能实现多选。

3.根据选中的内容生成二维码。

4.将二维码打印。

### 整体效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

### 源码下载 ###

[https://download.csdn.net/download/badao\_liumang\_qizhi/11634153][https_download.csdn.net_download_badao_liumang_qizhi_11634153]

## 实现 ##

### 导入Excel并显示效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

### 获取选中行效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

### 实现参照 ###

Winform中使用NPOI实现Excel导入并赋值给DataTable：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100064821][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100064821]

Winform中给DataGridView添加多选框列并获取选中行的内容：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100066614][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100066614]

### 生成二维码效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3][]

### 实现参照 ###

Winform中使用zxing实现二维码生成(附dll下载)：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100127535][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100127535]

Winform中使用zxing和Graphics实现自定义绘制二维码布局：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100127885][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100127885]

### 打印效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4][]

### 实现参照 ###

Winform中使用printDocument控件打印pictureBox中的二维码照片：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100128128][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100128128]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/234e57d9c94b44818b88b05044bb3d25.jpg
[https_download.csdn.net_download_badao_liumang_qizhi_11634153]: https://download.csdn.net/download/badao_liumang_qizhi/11634153
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/5ea00f9f902d440b9996c6aacbae41a2.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/966a7095ca86447c8ca429f6a9319ae3.jpg
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100064821]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100064821
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100066614]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100066614
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/d9b9db194fc84cfbbcd5008a70eeb423.jpg
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100127535]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100127535
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100127885]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100127885
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/7297c459f99a45e6b0fbc100f135a87a.jpg
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100128128]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100128128