フレームExcel印刷

frame.htm

<HTML>
<HEAD>
<TITLE>Excel 印刷</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=shift_jis">
</HEAD>
<FRAMESET id="TopFrame" rows="65,120,*" FRAMEBORDER=0 FRAMESPACING=0>
	<FRAME name="HeadFrame" src="control.asp?view=head">
	<FRAME name="Excel" src="excel.htm">
	<FRAME name="BodyFrame" src="control.asp?view=body">
</FRAMESET>
</HTML>

control.asp

<%
' **********************************************************
' 外部ファイル
' **********************************************************
%><!-- #include virtual = "/asp/common.inc" --><%
%><!-- #include virtual = "/asp/dbMySQL.inc" --><%
%><!-- #include file = "model.inc" --><%

' **********************************************************
' 定数定義
' **********************************************************
Const PASS_MESSAGE = "1"
Const PASS_HEAD = "2"
Const PASS_BODY = "3"

' **********************************************************
' グローバル変数定義
' **********************************************************
Dim ErrMessage		' エラー処理用
Dim InData			' 埋め込み用
Dim OutData			' 埋め込み用
Dim Cn,Rs			' データベース用

if MyData( "In1Meisyo" ) <> "" then
	Call SetCookie( "In1Meisyo", MyData( "In1Meisyo" ) )
end if

Call DBConnect( Cn, "ASPMySQL", "lightbox", "root", "" )

' **********************************************************
' 処理コントロール
' **********************************************************
Select Case Request.ServerVariables( "REQUEST_METHOD" )
	Case "GET","POST"
		Select Case MyData("GNO")
			Case PASS_HEAD
				Call GetData( )
				if ErrMessage <> "" then
					MyData("GNO") = PASS_MESSAGE
				end if
			Case PASS_BODY
				Call GetData( )
				if ErrMessage <> "" then
					MyData("GNO") = PASS_MESSAGE
				end if
		End Select
End Select

' **********************************************************
' ビュー
' **********************************************************
Call CreateInData( )
Select Case MyData("GNO")
	Case PASS_MESSAGE
		%><!-- #include file = "viewmessage.inc" --><%

	Case PASS_HEAD
		Call EditDataBody()
		%><!-- #include file = "view2.inc" --><%

	Case PASS_BODY
		Call EditDataBody()
		%><!-- #include file = "view2.inc" --><%

	Case Else
		if MyData("view") = "head" then
			Call RestoreCookie( )
			Call EditDataHead( )
			%><!-- #include file = "view.inc" --><%
		end if
		if MyData("view") = "body" then
			%><!-- #include file = "viewmessage.inc" --><%
		end if
End Select

Call DBClose( Cn )
Call DBClose( Rs )

' **********************************************************
' デバッグ用
' **********************************************************
'Call DispData()

%>