sql到textbox到excel(格式化)邮寄 [英] sql to textbox to excel (formatted) to mail

问题描述

我的表格很小

员工编号---文本框

员工姓名----文本框

员工部门----文本框

员工工资-----文本框

员工年龄----文本框



现在我有一个带有搜索文本框的网页

员工编号-----文本框(搜索crtiretia)

当用户键入员工编号时，所有sql数据均应填写包含员工姓名，工资，年龄，部门等信息的表格.

下一个

我有2个按钮

excel导出

自动邮件



在excel导出中，我具有指定的格式




我实际上需要的是什么

当我单击导出按钮文本框数据时，应发送到EXCEL文件

和特定的文本框数据应在特定的单元格中接收.

例如:-TEXTBOX1发送到C3或C4

文本框2发送G9



当我点击邮件按钮时

应将数据发送至附件并自动执行





，我有3个具有不同格式的EXCEL文件

导出按钮应使用其各自的数据查看所有EXCEL文件

和邮件按钮应向EXCEL文件发送DATA，其中1个用户I EXCEL文件

2ND USER 2ND EXCEL FILE

3RD USER 3 EXCEL FILE




请帮助，它非常紧急

并请使用完整的解决方案.

i have a small form

employeenumber ---textbox

employee name ---- textbox

employee department ---- textbox

employee sal ----- textbox

employee age ---- textbox



now i have a webpage with search textbos

employeenumber ----- textbox (search crtiretia)

when user types employee number all the sql realted data should fill the form conataineing employee name, sal, age , dept etc.

next

i have 2 buttons

excel export

automail



in excel export i have a specified format




WHAT I ACTUALLY NEED IS

WHEN I CLICK EXPORT BUTTON TEXTBOX DATA SHOULD BE SEND TO EXCEL FILE

AND PARTICULAR TEXTBOX DATA SHOULD BE RECEIVED AT PARTICULAR CELL.

E.G:- TEXTBOX1 TO SEND TO C3 OR C4

TEXTBOX 2 TO SEND G9



WHEN I CLICK MAIL BUTTON

THAT DATA SHOULD BE SEND TO EXCEL AND AUTOMAILED AS ATTACHMENT





, I HAVE 3 EXCEL FILES WITH DIFFERENT FORMATS

EXPORT BUTTON SHOULD VIEW ALL THE EXCEL FILES WITH THEIR RESPECTIVE DATA

AND MAIL BUTTON SHOULD SEND MAIL THE EXCEL FILES WITH DATA , 1 USER I EXCEL FILE

2ND USER 2ND EXCEL FILE

3RD USER 3 EXCEL FILE




PLEASE HELP , ITS VERY URGENT

AND PLEASE HELP WITH COMPLETE SOLUTION.

推荐答案

您好，请检查本文:

Hi, please check this article: Exporting Data to Excel[^]

这篇关于sql到textbox到excel(格式化)邮寄的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！