Excel图表转成图片

时间:2022-07-10 00:22:23

关于excel 图表转成图片

知识点:excel 生成的图表不是图片

尝试.    通过Java调用POI接口挺难把excel生成的图表转成图片导出来

ps.      其它生成图表的工具,如jfreechart,参考链接:http://www.open-open.com/lib/view/open1365997415828.html

       但是生成的图表会和Excel生成的有差异

办法一:excel中创建宏,将图表生成图片到指定目录,

只需要几行代码:

Sub SaveChartAsGIF ()
    Fname = ThisWorkbook.Path & "\" & ActiveChart.Name &
".gif"
    ActiveChart.ExportFileName:=Fname, FilterName:="GIF"
    End Sub

    参考链接: http://soft.yesky.com/office/122/2296622.shtml

办法二:VBA编程:

    用VBA先转成图片,并为有规律的图片名,插入PPT如果也用VBA实现,那只要按2次快捷键(包括转换图片)。

    当然也可一次在PPT中实现,只要在PPT的VBA中CreateObject("Excel.application")。

办法三:perl编程:

    用PERL则只要写个脚本运行一次,就可以把excel中的图表生成图片,并转到ppt中(PERL中使用Win32-OLE和Win32-PowerPoint模块)。

    用PERL还能很简单地实现图片缩放和排版,一句代码搞定:

    $pp->add_picture($picture, { left => $left, top => $top
,width=>650,height=>300})。

    方法二、三的思路 参考:http://club.excelhome.net/thread-250076-1-1.html  中aef25uuu 的回复

   

    代码实现:

    一、     
save
a chart from Microsoft Excel as GIF/JPEG/PNG

参考:http://www.uni-hildesheim.de/rz/DOC/perl/html/faq/Windows/ActivePerl-Winfaq12.html

    中的“How do I save a chart from Microsoft Excel
as GIF/JPEG/PNG?”部分

代码:

    
use strict;
use Win32::OLE qw(in with);
use Win32::OLE::Const;
use Win32::OLE::Const 'Microsoft Excel';
$Win32::OLE::Warn = ; # die on errors... my $filename = 'E:\\visual box\\share\\perl\\DataTemplate1.xlsx';
my $filter = 'JPG'; # can be GIF, JPG, JPEG or PNG
my $count = ; my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
|| Win32::OLE->new('Excel.Application', 'Quit'); # use the Excel application if it's open, otherwise open new
my $Book = $Excel->Workbooks->Open( $filename ); # open the file
foreach my $Sheet (in $Book->Sheets) { # loop through all sheets
foreach my $ChartObj (in $Sheet->ChartObjects) { # loop through all chartobjects in the sheet
my $savename = "$filename." . $count++ . ".$filter";
$ChartObj->Chart->Export({
FileName => $savename,
FilterName => $filter,
Interactive => });
}
}
$Book->Close;

ExcelChartToImage

    二、      perl 把excel转成html

    参考:http://zyj4538.blog.163.com/blog/static/2765753220112285537776/

    

    遇到问题:

    一、  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAoYAAADoCAIAAAD9ibItAAAgAElEQVR4nO2dMZI0uW6E+6zyZek6OoFCp1DEmnIUIVemDBnPlPtkPKnVWwQSmSBZxZ7JL9aoqSaBBAgS3ft3zbz++y//+de//vXf/+1f//Jf//HP//SP//D3f/cyxhhjzP24JRtjjDFH4JZsjDHGHIFbsjHGGHMEbsnGGGPMEbglG2OMMUfglmyMMcYcgVuyMcYYcwRuycYYY8wRuCUbY4wxR+CWbIwxxhyBW7IxxhhzBG7JxhhjzBGMLfmPf/lj/G+H692WSftbYzzQ70KyPO+OS63M3ZX8EkO+Qc8SvkWnMT+H8FPyZROWG7K3Y+85uO9Uohq5IQP7jH96GR3dcI5Lb7m2qmq0ri/qc18k1Zivh2nJnzzyqajHIy1ZsnPOm5IdXg6JbndL7tk/c8uEfJFUY76esiWH3Zf5VASOKvw/PMPBkp1MUsanndK+9CMTLxnX5x0+D6XTGb8g5PGlO/1K8ibrrVefuPjV/RLKUPPDSzXG7AK0ZH5X/w3+qJLGl3ZI+6RycMaN42fieuVHamkKn8VlHibjBdZGyqXc5HccOSNy4XV5h6yHmf1CmpWMGGMWoH5KxkhHA7n5mZZG2pdkM+dUZj9rLWRoWVyfd8Z2BSQBPYyd0G8Z3YN+GTGjayAS6Cz1S2JeUUteopPMzHyejTF9lvxb8jjgVe1z4IU5x2fsY4+kfj4P5B3G70yYZeqk/sG82oh3iV8wbNU1Yx/r5FvyKp0At2RjTkH9xnXZil7DabKp9T7Ykpl28orCZ0KeaclkD1vil1e1Nl7yVeyU8bu1PsGdS1pInZJfIIaRaozZxabnkplmmZ0m+BwJx2f3Gf0XC9LRnAV4yQOwA07S8Ggu8wkiDfWQ8TbWMfS+1S+IWqqrLISyHsgQ1LoCOiW/r6HqxvGZHSbPxphZ/Nu7fiFPHa8+1hfCvAdqmDLGPIlb8m/jqQ89/rC1nCUp9boYcxBuycYYY8wRuCUbY4wxR+CWbIwxxhyBW7IxxhhzBG7JxhhjzBEwzyW3jatG8Pjsocm2vE3coEp9GJeUtGq9ehl48Hvgd3pUObbOJyl3+rdE7f3+yEqN8R5bLZpC5ndcT4aqWiBb8hJtO9itStpvPbP8EZCNn+nK6qwZQLHt9isNPrDOQxbG9S1Re783vAMv0uDP8UwITVkr+IEted7yD2BfcmYWPRzfWJ1DWvIhh+xtelaxNq5viXor5+z3cvxRnSL8VPpsRW1pye84L+9N3neWLFWWSnx/pqTUuBg95X1JfCgbx9VLO1hHVRhvJ0vF7jyDfKp1xetXx3/qbOQzC3YsFSmf2EhjHXFhYzsgCSD27CY5Xr0vFVWWARAXb/aih5zLjJ+vz5klztSWCnfXQ+Y6Hs//veSyxLNE9GqFD4n0wsTCxFU6zYzwfpkQSPuNI0BaLzye3+r3X5OS+MHh7g0NSuv4+nOS23V+kbojn5I2bEodzOfB+/1iauF4aeOM43vTpRCwU6YeMlOr6kT444yX+PkjY3KdwH2pyslSZuLCvg7ZouXEbIxa4qv8StdgvUj7jXDw4KxOGjpnQgD5eUWLm41n1pSJa3RBxkXqxHnIrr3f1f3OjJfiIvcFI+n1f7uvNxHXM7mvyY05Gr/mQW3JjDPpVX483rRSRsiJvbj2bdFw5PItKukB4xvnzpJckflXwykHX7ZuudV5pzPhh68y5yBzX41LWhpSZ4b3O295yfjJ/c5bYMaPdZ7NXVXPM+fSn+i1ZCmVqxLdq85xPH8uqHkojcxv0XCwGtfnlK3j1XDuvGYkSUfVZQpTV6TO9s6f8dvI59q4ZpLwOYy3E5ot/ZL2G/qzwWpcn1O2jlfDYeqHNPX6vw2Y6c+mr6qHVXVSPJdcxpDdHF9ispyND+9fLhoFsSQuVX+oRNqi4XhJ5ytJ2qrxvXDG3cjkubzfyzNfVKW7Ma7MPq5DPoQyD5lONc9qXJ/jLxfZ1mN0lqng8yPtI0lnrw6z8ZLOl1JvjfG9cPj6wUYaVfFp5DVRD69oWSfrxL+9yxhjjDkDt2RjjDHmCNySjTHGmCNwSzbGGGOOwC3ZGGOMOQK3ZGOMMeYI3JKNMcaYI3iwJbcfJpv3mylpPBJHemw/Ujk+xEZO/7SjTpmkncwb8j8/vv0kJZgO/OIfwzvYtfR8qgT5KOdyevon9dx2fG0t9YbTRw7tEGmf3uB3TfKz3941KZpkSemQNzOP5ZEHLDD68RHcnkuSnY+SkR5hqplhvFk1/2M+yYn4Pv9O4vWxb8NrRnPbe2l/Zj9Kmneglrqk6tnmhB3tW8ospYe05L9xc0vevY+EX6i5g0lH0mLgtzaXMaTTXkvgp88cbVm8qp02ZPPY3ZKBr/KkI41LZfC5LktacoM7W/KDh8kq1zcf+pKjrH2uWsrzeVDtfS05NDqeKZ/3QVlkpkB/YuyE59qo9gITl9r2yDEginBKGfKMQn59sfJw3cvQGIU4IuC3nEt6x3Wb3S+zPdYtjgUUTLtI+Krg9WSxtNf3EkJpE+ehrGdVzxj7ZTyWlLkArjNtICfAPjCO3QGdWMbFeLi+0tJkanvxqoUausb3KcC/JeOlCq+Zbbnquoyc2bcX8aXN0j4YltkHQfEvNUSS68voaWzsy4/SlmjvW2n/8PfxuoCkhXPV+pSKhM/DZV3K2ngl65Ktb2Y/i7csfr4C2/GGFoC8cgCQpMY7YzMsQqlOsAZGUlnnjLWGzob+159XltTDgr/eJUVFbqGZazV4ZpdmJwKmsXjAPhn7ZPWXr+JjZaxCHFdj4ZigRmF4fNsvP5hcsskBZJ6ZIpEWKyQrhvEltWizeEs7alDqFsb3x+tQP95HfN74YBmbZU0CR+r6ZlPKOif1qDrBujRcqxYCym9cN1a0N7GxjaUdnk0BO4G0yQwu7TNHz2T1lwPwVlGNN15Vkz+/hcBL5FYHkpgYpXWXDPIhNM6R8fya3MujnUvIamJLd3zUTBob8ngjzHqpdaXaLx2VE/GUbN0law2djeJnXPRhHoKSVjfUt+M6Ewb0hyNxWvmjhxmPpb7nMlulUf3lGLxVpFgY12W8r9X5b581OK4yb4yXdp2T8Tb2V0apecb+p3HGV5aHbC4YL8WrhrlqXYBsaf8u3NefG7ncj6VOvH0YPWVQS+pTshPmIYZ8LvkzTRfr2WKAlz5vhqay+8AFDvOiPFwtsqSAnUwPGD/qzPJwuWiEzPsFIeObquvRb2Yqsz85nslDWIflumS+wjRineGmKPXg8dgITlFPP2OctA/8ZtFleiRVwPJYBnhfZMbLeLHacokvN7PrUj8YgPM22gnn8qWYmZrcF6TfUgzIQ4z0q0J40eY2xlJoL5PX1xgjAVodM8Vc4Vvy5HFvDsfra4xp0Pv/DT5nYvw7ro0xxpgjcEs2xhhjjsAt2RhjjDkCt2RjjDHmCNySjTHGmCPAf3Zi6/fi8PNqO+wvpKFzVbzqlG/5cuPhOlc9aXYDZyp8SlL2+Oy+Lwn3iiR7uJac/mlHnTJJO5k35H9+/OX+5PEbLvGfrJV/nHHfLiJTUBpR7c/ztrykNTZ0uiUvdCoNvuyuhcaXIx1Ju8W8HU36ynYQ7xEckaUFRj8+gttzScIp96xvmGpmGG9Wzb+0YfnzmX8n8R6cXQcGx5Y8XxaTqO9uduvZ7Xd3SzYZM6dD+FJv627iwH006Uh6Uxt/BEk+ppBOey2Bnz5z9mbxqnbakPW/uyUDX3j62v0ytuHLAvVb8ugmjHN8KXxrAOyAgCW/wD5jJ0sxVtjwq8bbkLok3qyMGJ2voQzCkLFO3u9MHvhUvK+zkLMpy+NdVVdg8BjapM6wBqR6AC74JOBsZDCDsf2yHkDIMwr59cXKw3UvQ2MU4oiA33Iu6Z3fL+W6hPvlMiVVwrfkcjuNnsCuA5r4rOEVAoN5kZlZvE/4kt2nU7XPWMhKauY606n6ZZDqJ5uOl15ymr2UuZjJ50z+s+sd9cDkJ6RRVKXN0j4Yltlv1EPDO/MSWFOsJ6zPzHVoRNpE7U3H6Gncx+sCkhbOvTr9ipacraK0RRtHAGm51MnMyozM6AT2JTufSsZtSeos/YJ1Z/wy+qX6yey8r9sTszyE8Wb6S/FkXZVTsutwXfh4G7WthgzuhLIly3gkti/VgyQAD2PsgzrBcTUWjglqFIbHt/3yg8kl6w0Q/i25LCN+Z0opkOJv2FlV96WdRrySfVLtjngZnY38SH4Z8VL9YFPhS0w1qnratdoLdsnyrbrGETFjsqKStkBju5X21XqY2arZgPC6nf/Gq2ryl29YZjAeqR5r9brz37hm1lKSS6aAKVkpF5LIEOlIWhVvuzQ37XNVZyM/vTzz45ljCOgZTWEj7zGlHkZ/+yzIxo8j2+52XGfCgP5wJM75uI6MtdIg0EnWw8xWzcaE9tX65F2X8b5W518SnA3GJVTWJFPDfxojPZcMbgK52A4YP97P3GXrBOzj/AJCI1hnO15Qf6rUuhQm4sX57+Wn4bcMYQyZtzOKJL1fjGT6J+sKSy1dlDoZI2rdqnG96PXCiwUWsRxcjsf2R51ZHsaNoIbM+2VKkVx37BrU/8VUZn9yPJOHsA7Ldcl8hWlEOrf+9i4mKeYH4wL4arx8BxK+2+gtk9f3RPa15MlyMd+OC+Cr8fL9bLy+h+LfcW2MMcYcgVuyMcYYcwRuycYYY8wRuCUbY4wxR+CWbIwxxhxB4y9B8V/Sy77Ut+rLfurzaqvo6Z/Uc9vXI/lH+rZ+aXO58fO/X4pDvrmelzxmY4zR2NeSx2ei8bUKsHNn6xpvSuPB4EkLM2BHY9q3duWTDe7g5pa8Y28aY5rc8/eS72zJD/atVa7v/5zEO7oz7W7JN7tzSzbmYaSWzPwPrtDLTI/J9Hx6nDlKsv9BV9rEecheausZY7+Mx5IyF8B1pi38sbwGxvF9nKKZuPBNICAUGdaPtPRZ1KV4Mg+S68Z0Y8wsoCVnpxJ5Ln/e4c/38KCRWg5z/obH7vgjPp74FtKON7QA5JUDgKTJeMtrVQ8jYyYuYCfMJwDHm+0jxhq434hL8pvtI2PMRna35Oy+us/HoyE7N9UjKYt3skUBRyW9ThPqD0/V8D6OV+qOuEWN1rDOzx8bdsqkgfxkgTN5KPcRYw3cb8TVcMq8aoxZBv7jjEwrYlogPmoZ8HnNtxagLWxpwA7Zt8hXmZFSmDNGyPWSTE36bdtp1IZanwe2ZF48M8Ut2Zib2NeSV7XMTM/JLVnqkWS8aph3tq4sFZO+cKvbF2MZcrbuoU5QEsBFeX95/Ut2wjwYY2aRWvLnOcu0rvFczowAypOI6QeT9oHfLLpMj6QKWL4IC82W+WHiLZtT2cDwNfCb5W1JXJkdHBSzviDGMEuZHVxvTD6lSpNSwds3xgj4t3eZTfyeI/v3RGqM2YtbslmL9BHtB/Db4jXGbMQt2RhjjDkCt2RjjDHmCNySjTHGmCNwSzbGGGOOwC3ZGGOMOYLsF2oyD0eWjzCCm9mPGY0vteLnR1U753+fdlW8vP2tPJ72mwXg/XUUZyp8ShJ4aLvxaDjpsbEE2XlOTv+0o06ZZNVz9kvsLx9/vY9/VQi4fn2sDR4T9gkwAIhulCB/v2HqKJbEC0ben4SFHnt25gXMvIlk9kVT1gqkI2m3mLejHeslbQr1fAOHJ+PxMr09lySccs/6hqlmhvFm1fxLG/aOlpzJYlryTBVO8lNbcob6bm63Hp5Vetp2JgXMnA7hS/j0v5kD62rTeoFzDy9KOAAY77UEfvpMS87iVe20Iet/d0sGvvB01ni7JZNhgJb8B/3BF2+V0oUqKbw/v9VJvxenY57xlHa8md9J/avyU+rJimoyLiYENZ/Yzvs6dAGmkHrGWbv3ERg8hjap82In9N5YLzUJOBsZzGBsv6wHEPKMQn59sfJw3cvQGIU4IuC3nEt6Z/cLaMnkEuIwyv1TZoEZyS/heJ/ZxuP1qArfb/jip0vxkqlYnjcGxgWwP64FkHGzfn46sylIp2R+yrnM/lLHM+6W7CM+Lqn+y6BG2RhyZGm/UQ8N78xLq/Yvdh0akTZRe9MxeuT7az8lj0JxyZKJwMFkRnpLyGxdCUZGVrvMMDXeV543HCa5n9v7HOvht3Q5LHS6Wz9DuL8aE3v5AXkonY5G+K2XXV90qvXWWFM1ZHAnlC1ZxiOxfakeJAF4GL9/wX7J4mosHBPUKAyPb/tlBz/1b8mf13zWsB1mFqOQtE+i2v8sEWaY5Agbmd9vpUhslt/Skv52eSzUz1AeOszqqHraa9cLtl026sRGXI2zKNuG7RIqIe2r9dBYvnJAuX8l441XJ/dviRQLezp91zeus5vSepB1ObNUjE6mdiVJk/FeXJf5XJU39ciQio2cu1s/WT/Z/nq/hI28x0j5aeeBr6tsYtvdjutMGNAfjsQ5H9eRsVYaBDrV/YWRdsSq/Uu6LuN9rc6/JDgbfL2/47nkcIoqNLScvRRmigkBu8jsq5T2yfyQyefjzdwBndL6kkkL9VwusnjLJJNxlXpU/cAvNoIDKY1kcQGzmX6mbpnxjE7GiLpealwver3wYoFFLAeX47H9UWeWh8tFI2TeL1OK5Lpj16D+L6Yy+5PjmTyEdfj/9/3bu74IpgiM+RZczwcSvtvoLZPXt4Nb8rcwuT2MOQrX88/G69vELdkYY4w5ArdkY4wx5gjcko0xxpgjcEs2xhhjjsAt2RhjjDkC8FwyaSF8vOzzGgwYfwzvYNczz4317L/oh/mW+y1nzTttW1jraP4ZDN7+WoNLrO0Ah3xzPS95zMaYn0b527sAl+egw+v3yPA69MV7L+3PbHVJ8w6ytwLSeDB40sIM2NGY9q1d+WSDO7i5Je/Ym8b8WNoteWzDlze87Zbc4M6W/GDfWuX6/s9JvKM70+6WfLM7t2RjCqQ/zvhm3Fq4JWdzganLACCG98XMHd9qhCKxzdH+GEJpE+che6mtZ4z9Mh5LylwA15m28MfyGhjH93GKZuLCN4GAUGRYP9LSZ1GX4sk8SK4b0435+Uh/diK883lkhHOz6dmpRJ7LwAWwEx40Usthzt/w2B1/xMcT30La8YYWgLxyAJA0GW95rephZMzEBeyE+QTgeLN9xFgD9xtxSX6zfWTMr0ZtyWWf4AdkRwl5NIApYGTGeDRk56Z6JGXxTrYo4Kik12lC/eGpGt7H8ZYZKK/LogVL/P6xYadMGshPFjiTh3IfMdbA/UZcDafMq8b8Ivb9veTyaFMNZuPxFBJ8XksJybSNJ6mU2NLd2kO5IY83Qq6XZGrSb9tOozbU+sQ6wVaSvDfqv6G/N8CY3wLfktWdzByFzFm/6VgMPe6wnx2djZ4n5U2NVw3zztaVpWLSV1nnm2IsQ87WPdQJSgK4KO8vr3/JTpgHY34+2XPJr2FXlOfm+ON4bl7GhHMvs8qjjTECaOsnjwzGPvCbRZfpkVQBy2MZjGbL/DDx4rrCEZFHfOY3y9uSuDI7OChmfUGMYZYyO7jemHxKlSalgrdvzI/Cv73LfCm/58j+PZEa89txSzbfhfQR7Qfw2+I15lfjlmyMMcYcgVuyMcYYcwRuycYYY8wRuCUbY4wxR+CWbIwxxhxB1pJv+J4nfv5yh/2FNHSuiled8i1f1j1cJ3iO+TTOVPiUJPDQc+PRatJjYwmyh8XJ6Z921CmTfMW53di8M+veH9/4sxOryCyrdazan+dteUlrbOh0S17oVBr8Ob6c+2zapaNht5i3o0lf2Q7iPY6LiCWphyGwPzOXJJxyz/qGqV5iRzW15JidWXfpoKhb8nxZTKK+y9itZ7ff3S3ZZMzs0vAlfPrfzIH7aNKR9KY2+8gyHp37WvLFvuSLdHcZDFJB2mmzr/6X7NPdLRn4wtPlljxODv2NL72v8ZRaougX2GfsZInDCht+1XgbUpfE+zlSzfNrKIMwZKyT9zuTBz4V7+ss5GzK8nhX1RUYPIY2qTOsAakegAs+CTgbGcxgbL+sBxDyjEJ+fbHycN3L0EC85X2w7r16JinjLeeS3q8v8S253E6jerDrgEpePc4UGMyLzMzifcJX5z6dqn3GQlamM9eZTtUvg1Q/2XS89JLT7CXmoFHzOZP/7HpHPTD5CWkUVWmztA+GZfYb9dDwzrwE1hTrCeszc722Dtt2Gpu3vdmZPKT3v6IlZ9mUtmjjCCAtlzqZWZmRGZ3AvmTnU8m4LUmd7a1I+mX0S/WT2XlftydmeQjjzfSX4sm6Kqdk1+G68PE2alsNGdwJZUuW8UhsX6oHSQAextgHdYLj4hdOEpmNb9QzKeAyBtjnQwD3rzf5f0suy4jfmZJusmTbdlbVfWmnEa9kn1S7I15GZyM/kl9GvFQ/2FT4ElONqp52rfaCXbJ8q65xRMyYrKikLdDYbqV9tR5mtmo2ILxu5199lTlAwMgdZ1c2ZvlBge70/l5yNoAZVurm6xKXEWlnVd1LZ9Y9OiX7vIWezkZ+ennmxzPHENAzmsJG3mNKPYx+NZ983vgtP6OzERe5Xlgqzvm4joy10iDQSdbDzFbNxoT21frkXZfxZjd7BSn5XbvuUqKug6XnksFNoAzbAePH+5m7LF/AfiOVwAjW2Y4X1IEqtSzrmXhx/nv5afgtQxhD5u2MIknvFyOZ/sm6wlJLF6VOxohat2pcL3q98GKBRSwHl+Ox/VFnlodxI6gh836ZUiTXHbsG9Y/tlONBsKXfhv3lev5/1tbf3sWIMz8YF8BX4+U7kPDdRm+ZvL4nsq8lT5aL+XZcAF+Nl+9n4/U9FP+Oa2OMMeYI3JKNMcaYI3BLNsYYY47ALdkYY4w5ArdkY4wx5ghAS2aeDAOE0y+msgHjj+Ed7HrmubGe/ZeepVV+y1nzTtsW1jo6s07Ak5TA+M1fecUedysBm8Vf+jXmf+Fbcngn5PIcdHg9Glx11DL2Z04BSfMOsrcC0ngweNLCDNjRWD/hlNvqZBxG1sM4rFS7kEdaMl4md2Vj/hfpf1xLH2KyTwPtltzgzpb8YN9a5fqpz0+MI7Xttf2Sa8roeTyfITd7v2z/EyQZcy7gd1xnRz/YYON5hFtyNheY4sXwvpi541uNUCS2OdofQyht4jxkL7X1jLFfxmNJmQvgOtMGwgf2d9SJpKecHkoaB4d1Ii1xpkrN2xKn/KvG/CLa/+Mav/r681ESzs2mh6c8sA8GM+fseLSNZpmWkx1hmf0s3vJMLzMzH29oAcgrBwBJarxP1QljXwofuAYey/qRrJFxSevVcEoaMebns6olSycjHrDkqCWdloxHRtiHSD2hkvGElVpU6W7tYT1eh/rDlhPeZ1pmeOeROplxl4U8egFOw4QDwUwIUiBgfRtOmVeN+UUsaclM52BaTjimNJiNx1NIsr7CX2PLr+9vyQuNkOv1VJ3MuFPLI3Mxxg5SUVqbDKQXgvqqMb+I+Zas7vDdLXnhmVhqnrGfHamNniflTY1XDXPVugDZj9RJQw9papwi7Tu8DYFafH/hPgpHYjthHoz5+ZRf7wqPgMt2Ci2XO5xvLVgPHo+NANr6yaOEsQ/8ZtFleiRVwPJYBqPZMj9MvEDtI3WCs8fYGfPWW0cQC1CIQ5vPm+oU2+HtG/Oj8G/vMuZw3JyM+S24JRtzMtJHUmPMd+OWbIwxxhyBW7IxxhhzBG7JxhhjzBG4JRtjjDFH4JZsjDHGHMHYkvmHF6VHPC83sx8zGl86xc93qnbO/77rqnh5+1t5PO03C8D76yjOVPiUJPBQdePRbdJjYwmy85yc/mlHnTLJV5xjjc0bDwa/KmQMYOymzJiwT4ABmXRycGm5sSSnnT4hS+IFI+9PwkKPPTvzAmbeRDL7oilrBVIL2S3m7WjHekmbQj3fwOHJeLxMb88lCafcs75hqpfYUU0taSvpus+05PAm2ZJnqnCSn9qSM6Sj86gwH39fPClgZpeGL+HT/2YOrKtN6wXOPbwo4QBgXD0M1bN0piVn8ap22uyr/yX79PmWTNYBaMl/0B988VYpXaiSwvvzW530e3E65hlPaceb+Z3Uvyo/pZ6sqCbjYkJQ84ntvK9DF2AKqWectXsfgcFjaJM6L3ZC7431UpOAs5HBDMb2y3oAIc8o5NcXKw/XvQwNxFveB+veq2eSNF7md1xn6hkp5f4pI2FG8qs13me28Xg9qsL3G7746VK8ZCqW542BcQHsj2sBZNysn5/ObArSKZmfci6zv9TxjLsl+4iPS6r/MqhRNoYcWdpv1EPDO/PSqv2LXa+tw7adxuaNx6/9lDw6wCVLBoAXIzMiLeFop1GvDfHgGldwu2Rfed5wmGTpt/c51sNv6XJY6HS3foZwfzUm9vID8lA6HY3wWy+7vuhU662xpmrI4E4oW7KMR2L7Uj1IAvAwfv+C/ZLFxS+cJDIb36hnUsBlzNX+U/+WfAmbVI/tMLMYhaR9EtX+51IxwyRH2Mj8fitFYrP8lpb0t8tjoX6G8tBhVkfV0167XrDtslEnNuJqnEXZNmyXUAlpX62HxvKVA8r9KxlXX+VPA+l8YIZNnRvf9Y1rKqTKMlmXjXotxUvXeEe1S5BZLCafq/KmHhlSsZFzd+vvbe/RFDbyHiPlp50Hvq6yiW13O64zYUB/OBLnfFxHxlppEOhU9xdG2hGr9i/puow3u9krSMmvsO47nksOp2QZaSQ6jBNL5e8z9lVK+2R+yOTz8WbugE5pfcmkhXouF1m8ZZLJuEo9qn7gFxvBgZRGsriA2Uw/U7fMeEYnY0RdLzWuF71eeLHAIpaDy/HY/qgzy8PlohEy75cpRXLdsWtQ/9hOOR4EW/rV7Pu3d30RTHEY8y24ng8kfLfRWyavbwe35G9hcnsYcxSu55+N17eJW7IxxhhzBG7JxhhjzBG4JRtjjDFH4JZsjDHGHIFbsjHGGHMEUktWv0SHxzNPhpXGwx/Bk2fZj+Ed7HrmObae/ZeepVV+y1nzTtsW1jo6s4v3WjcAAAgJSURBVE7Ak5Tlw5e3feVV2u87vEt6jDkRviWPPe/zJeCC36Lk5vkjef7985rR3PZe2p85BSTNO8jeCkjjweBJCzNgR2P9hFNuq5NxGFkP0vZcziMtGS+Tu7L5Gnr/41pqFeqnCnJM9mmg3ZIb3NmSH+xbq1w/cliTjtS21/ZLrimj5/F8htzs/bL9T5BkTJ8lLTm8Uw7G98uzhmnJQEZmihfD+2Lmjm81QpHY5mh/DKG0ifOQvdTWM8Z+GY8lZS6A60wbCB/Y31Enkp5yeihpHBzWibTEmSo1b0uc8q8acxBqSybPtd59fNyAczycm00PT3lgHwxm4hqPttEs03KyIyyzn8VbnullZubjDS0AeeUAIEmN96k6YexL4QPXwGNZP5I1Mi5pvRpOSSPGPM+qT8ngPj8Y7EbpZMQDlhy1pNOS8cgI+xCpJ1QynrBSiyrdrT2sx+tQf9hywvs4XnDnkTqZcZeFPHoBTsOEA8FMCFIgYH0bTplXjTmItS05fKl3+qidg2k54ZjSIB9CY+dnfYW/xpZf39+SFxoh1+upOplxp5ZH5mKMHaSitDYZSC8E9VVjDiJryXyrGGkfQPhoIL0wR/COs69xrJSaZ+xnR2qj50l5U+NVw1y1LkD2I3XS0EOaGqdI+w5vQ6AW31+4j8KR2E6YB2Oeh2/JnzeZfnAZP+6Qy/3LxefgzAXe4XxrwXrweGwEp6innzxKGPvAbxZdpkdSBSyPZTCaLfPDxAvUPlInOHuMnTFvvXUEsQCFOLT5vKlOsR3evjG34t/eZcwvx83JmFNwSzbmNyN9JDXG7MUt2RhjjDkCt2RjjDHmCNySjTHGmCNwSzbGGGOOwC3ZGGOMOYLyueR938PEz0fusL+Qhs5V8apTvuXLtOfrfGRTPKtnCapOPH5fvN+ST/OTCVsyeIp/IUu2HBh5g/IlrbGh0y15oVN+5O5N0WgJ37K4L13qzS35nkPPmIKxJYe/AedOSeq76d16dvvd3ZJNRrv57ch/z/4XVcKqlrwJt2RzBGVL/iR8F/95MyxrPCXz0vYL7DN2iJwV799Jv2q8DalL4v0cqeb5NZRBGDLWyfudyUNpqrcv1Hj58ZmqmX0RypDq5GINSyUNYv1gEdU6aUs1Zhl8S86OjM+tyAwLDTL3x5fwziGPPCwyM4u3unQkbdKp2mcs4LN7Uj+oEMYvg1Q/2XSy5HZfl3fGdC3RCejtd8YauL97vxhzK1/Rkt9HoXSk7tu6WHl2cEtHzGhn1RHTjveyvqrO0i9Yd8Yvo1+qH2yttI+vs/GqTrCtsv04qZPMDBBGIu2XJfobIo1ZDP9vyeU2JoeNli+QWw5YkOyUraK0TNppxCvZJ9XuiJfR2ciP5JcRL9UPaWfmmtQp3cz24yqdgN5+Z6yB+5v0G/MM/Deuy9Lnd352J7zPHKnMabXwGCrdtXvYWp2Sfd5CT2cjP7088+Nx/UzG+/5xcn3VTZTtR1Kn5BeI4fd7xs37pRGvMeuRnksuj5hXVNnYDhg/3s/cZfsH2AeCccZCI1hnO15wLqhSmaO5HS/Ofy8/Db9lCGPIPTv8uvD6wbowec48hnnGwkq/ryRv5bqT2Zb2SyNvklMQrzHr2frbu1zEvxwXwPmAljZjyhjTYV9LVj/KmB+GC+BbWLJSXm5jFuDfcW2MMcYcgVuyMcYYcwRuycYYY8wRuCUbY4wxR+CWbIwxxhxB9tu7mIcCy0cA1ecmAY0vc5LPce5w/Qir4uXtb+XxtN8v4IYvLUvGv+VL1KpOPH5fvN+ST/Mk0t9LHrspMybsE2DAyHtM40Dh7zdMHcWSeMHI+5Ow0GPPzryAXrluSnWjJXxF5f+N+bfsPTsNd1+UVXM3My05vEm2ZKk611bwT23JGeqnh916eB7/fD8poN38dixEz/5pJQFY1ZI34ZZsKNotmSwv0JL5D774/WzpQpUU3p8/mkm/F6djnvGUdryZ30n9q/JT6smKajIuJgQ1n8CIaj+cu2R8pmomn6EMKckXa1gqaRDrB4uo1nlbqvlFgJZMVicuL2ZL4+pkRkpblDyq8PWoCt9v+OKnS/GSqVieNwbGBbCfndpledygn59OLsHu6/LOuBxLdAJ69c9YA/eX14mq0/wu1n5KHs8UvKXLMygzcnFXngvg/sXIkqNZlRFej0de70jKRjKLBewsP2qxnkvZAEnlsNDpbv085Hrh62y8qhPvX+y6p5PMDF//jDVwf6H+hkjz63jq35I/r8saLf0ywniFpH0S1X555GVmJ48YYEGyo+aN1POZFlV/uzwW6i9R86nmvLdfQJldlmOVTkCv/hlr4P4m/cbEfNc3rrOb7TOXDHZmL7WPKv6kWxLvxXWZz1V5I4unPPqZDOxoG+18knZK+5ProhZVVp+kTskvEMPXf8bkfllYJ68kXvMb2fFccjjlMjL7cSQ0cnnpFVU8EwJ2kdlXKe2T+SGTz8ebuQM6pfUlkxbquVxk8ZZJJuMq9aj6gd/SDq8H7wtyXZbXJxZW+n0R68XUf4a0Xxp5k5yCeM1vxL+964vwpjVfB2hpM6aM+Zm4JX8L0ltyY85hSem6/s2vwC3ZGGOMOQK3ZGOMMeYI3JKNMcaYI3BLNsYYY47ALdkYY4w5ArdkY4wx5gjcko0xxpgjcEs2xhhjjsAt2RhjjDkCt2RjjDHmCNySjTHGmCNwSzbGGGOOwC3ZGGOMOQK3ZGOMMeYI3JKNMcaYI3BLNsYYY07gfwCeXxskextW4QAAAABJRU5ErkJggg==" alt="" />

        描述:Perl lib version <v5.8.3> doesn't match executable version <v5.8.8>

           at E:\oracle\product\10.2.0\db_1\perl\5.8.3\lib....

        原因:之前安装过oracle,其中默认安装了perl;现在安装的perl与其冲突了,

        解决办法:将现在perl安装目录下lib目录中的Config.pm、Config.pod拷贝到oracle中对应的perl下:

        E:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86-multi-thread

    二、  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhIAAAAuCAIAAADyeGcXAAAGAUlEQVR4nO2bMQ7kNgxFfdb0qXKdnCDIKQJsmSZA2hwgRc6QbmBY4tcnJXs8nvewhVeWyU+KEj0L7/b3X3/+9+8/v//26y8///Tjjx/tny3J65Hu45H9yON+sDs/Gnf0HyzsJ3ct6L928yDsdBPVjUuE469Ua8qMt7COXe+n+hVRp+oqCmFYD2YI2boSOlN+t6bq2vmRHSfP8F3s28a7tcDpvOsI4OhZiNOnC6YAXGgb38O7Xh55aV3OkpSyLlCEtgEAAAloGwAAkIC2AQAACWgbAACQgLYBAAAJ2v+38boVfeXtmE19t17D/96//Qg99f27L3Xod2hfh2DKuCHZfJpL6dtPzRcWTqrn6Jvahd/aFvSc6jG7sz7io6+szlTRLicyPnZ6Rtu4YA+8Hh9q7o7ruEyb2kVKTBvLkzpHNp9mzfg1cNiZheUertGqej7VxaSYhRTawAfVf1bqW9rGlNNU25gU5xyL0Y4193khF/qAdoo72gOOmP2Dw0A+aOfsqeXTuY7y1paHb6eWeb+eJ0N2rDnyCmJWUbP/QcW/qm2chD6vVraNrsX9oH8oR+OXtQ1h6jCYyGPp10bhnEqJidZrCxa3tZ+yo8W01qJ11DqFnVZtyo7I8DBMv56FhcOFHhcy9D711ytlv/vskvmRKhFXZGe4Bfwkb/ESp9Z9GFoU73B+1mlCfLdtdHd1OyKWf4tz6iqLSck4iEmdEVEeHFWOUzPP5q3uHOG6O03vq6EdrUeYdbZ9ZGc4LpyK0LpiomqZqeczcOp8+Lh4ZJjbhdfDEbFP5/2mwk8ZGc4Xizip33fa57y2EY3P7zFfRpRZLeZwRhQqSd/V9n07ek73pIv8dsd1Yv38OPF2M3C4FdlxxtsJqfybMYoJ16DXvWZtaF9fR/OzOiMxW/w6MqnTzIwQZhLNF8mZ1O877XP4AFefBWYY5iPdmZFTYcSvDOFXeCxUkr5rVnPWhTMtVStCWGpj6Hzq9XXy5qyXmX/ncRGjiPoC1q7X2mtTZ2pwXwBbUw/zOgX68axBc1cu1O877XNG26gtVbTNuuORTtOdXmbnr6myHorR5R6NRBSOj2FEpp2hnshsoWacGijEYi6utvkaKeznMoVcpewM7V9wPnRHDqGZOlN+za0djWjMXVnL26TTPmbbOKQ7tTzaSBnH/l6ndu2Ul+9X5yGyP7RTSE5WzIwdU4+uGV+quV5da6n8Z/PzRtqy797y7Yjid0p0WMwzJerUjxY29LsFeTPrcJhtp+S6gfj6J5324X+JA8A3II7dGVPfCG0DAL6EJb8O7/YT8w3QNgAAIAFtAwAAEtA2AAAgAW0DAAAS0DYAACABbaNL7WOJk76vuOCzjdT38r611TLHHs9zmjL+KR/bZHXq+RdUaWoczoK2ISicFDcRs9ZFwfW82lrmT8pSoQ3cv2e8qL0WzNtJ8a5eBR1oG4JbHRNf1TbKmT/v117W/gcdZ6vaxkms/SkMC3hY2+hWktj2q350X1O78/+YUIvXt7Mfd6SK9fLtiDlL6qFWP8PkOHb2g62MVJIP1rRU06DWLxaxcOLPb1JYxpPaRrS9xbbvPqsHzWdPInuMLonXPEYdv47m8uPikazmmevhSNsGlugUZKX61sT42jqhbdyI57WN9kVGlKl4IWonD12vCGKBFzGtFq9O2vxx1uqp5TM6EE2dOq6szlTbWKLTzMxN2kZKv+8UruB5bUOPp465VEWeXb5rN9h82yjY9+eXM7/qOhWXORi1jVU6BTdsGyn9vlO4gqe2jW4Fm2XdnZDy3o5HxrPjWSVL2mThOFjVNmbsrKqHWrzzbeOgM+VXiLlV26hV9Yx4WMCT2sYWHAf7W9H8rVfNwpr2PhxMjac0tPoj4068zrhjf6iznV/LvK9HJ985/hy/wmM3n1rY0O82KkJhJ7VeTp0U8jbvFK7gYW0D4DGIY3fGFMAstA2A27LkVZr3cVgMbQMAABLQNgAAIAFtAwAAEtA2AAAgAW0DAAAS0DYAACABbQMAABLQNgAAIAFtAwAAEtA2AAAgAW0DAAB8/gd1aHEdy/NC4wAAAABJRU5ErkJggg==" alt="" />

        描述:运行上述写好的pl代码时,出现这个错误

        原因:本机上安装的Excel的问题,在别的电脑上运行时成功地生成了图片,可能是由于本机Excel是精简版的,W32-OLE获取不到Excel的com object

        解决办法:安装原装版的Excel,而不是精简版的

Excel图表转成图片的更多相关文章

  1. 如何把Excel中的单元格等对象保存成图片

    对于Excel中的很多对象,比如单元格(Cell),图形(shape),图表(chart)等等,有时需要将它们保存成一张图片.就像截图一样. 最近做一个Excel相关的项目,项目中遇到一个很变态的需求 ...

  2. C&num; 创建EXCEL图表并保存为图片

    数据表格能够清晰的呈现数据信息,但是我们对于一些繁杂多变的数据想要很直观的看到数据变化走势或者数据的占比时,数据图表会更具代表性,并且在呈现数据信息上也更形象,也能获取更多纯数字信息所不能直接展现的信 ...

  3. Java 将 PPT 形状(表格、文本框、心形、图表等)保存成图片

    MS PowerPoint中的表格.文本框.心形.图表.图片等均可以称为形状,将这些形状保存成图片,便可分类储存,方便日后查找,再利用. 本文将介绍如何使用 Spire.Presentation fo ...

  4. JAVA生成EXCEL图表

    跟据客户的要求,需要开发一套包括图形的报表,还需要导出WORD 图表需要这样: 这样: 这样: 还有这样: 接下来是实现思路: 以往用的最多的就是JFreechart,手上也有实现各种图形的资源,但是 ...

  5. 【原创】&period;NET读写Excel工具Spire&period;Xls使用&lpar;5&rpar;重量级的Excel图表功能

                  本博客所有文章分类的总目录:http://www.cnblogs.com/asxinyu/p/4288836.html .NET读写Excel工具Spire.Xls使用文章 ...

  6. 使用截图方式将Excel导出为PNG图片的不可行性

    博主前面一篇文章使用了JAVA的Robot机制 模拟打开Excel然后Robot移动到指定区域,截图并生成PNG格式图片 试图使用这种方式将复杂的Excel报表转化成无差别的PNG图片 但是这种方式遇 ...

  7. 《Excel图表之道》读书笔记

    一.突破常规的作图方法 突破Excel的默认颜色 非数据元素用淡色 突破Excel的图表布局 图表要素:主标题.副标题.图例.绘图.脚注 竖向构图 标明数据来源.图表注释.坐标轴截断符号 专业的水蓝色 ...

  8. 将Excel表格保存为图片

    如何将Excel表格保存为图片,可参见以下几种方法: 1.借助其它办法软件,例如Word或PPT. 步骤:选中Excel中需要被保存成图片的内容,Ctrl+C进行复制,打开Word或PPT办公软件,鼠 ...

  9. Aspose&period;cells 读取Excel表中的图片问题

    一.说明 本文主要是讲解,怎么使用aspose.cells读取Excel表中的图片,并把图片转换成流或是image对象. 二.开发环境说明 开发工具vs2012,c#语言, 三.Aspose.cell ...

随机推荐

  1. python中在同一个位置输出数据

    import sys, time def print_data(): for i in range(5): sys.stdout.write(str(i) + '\r') time.sleep(1) ...

  2. 关于STM32-MDK中preprocessor symbols解释

    preprocessor symbols 是预处理符号的意思,这里相当于宏定义,我们在使用STM32固件库时,由于固件库里面包含的是ST整个系列单片机的定义,如下图 这时在define框中可以作为一个 ...

  3. DNS解析全过程及原理

    DNS解析原理及过程. 当用户访问我们网站一个网页时,他需要经过以下步骤: 1)找到这个网页的存放服务器: 2)服务器将用户的请求信息接入: 3)服务器通过文件路径(URL)查找用户请求网页: 4)用 ...

  4. 设置UIImage的渲染模式:UIImage&period;renderingMode

    设置UIImage的渲染模式:UIImage.renderingMode 着色(Tint Color)是iOS7界面中的一个.设置UIImage的渲染模式:UIImage.renderingMode重 ...

  5. C&num;获取内网和外网IP

    写了个小客户端,里面用到了获取内网和外网的IP地址,代码如下: // InnerIP var ipHost = Dns.Resolve(Dns.GetHostName()); ]; innerIP = ...

  6. 解决statusStrip控件上的项目不能靠右对齐的问题

    在c#中用到了状态栏控件StatusStrip,但当我想把StatusStrip上某个StatusLabel靠右对齐时出了问题. 按照MSDN中的办法,是设置ToolStripStatusLabel的 ...

  7. 我的three&period;js学习记录(一)

    在之前因为项目需要使用WebGL技术做网页应用,但是苦于自己没有接触,只是使用过OpenGL.然后接触到了thre.js这个第三方库之后我突然心情很愉快,这将节省我很多时间. 过了这个项目之后,就再也 ...

  8. Date 类

    一.Date类型的初始化 1. Date(int year, int month, int date); 直接写入年份是得不到正确的结果的. 因为java中Date是从1900年开始算的,所以前面的第 ...

  9. UNIX网络编程——epoll 系列函数简介、与select、poll 的区别

    前面博客<<UNIX环境高级编程--epoll函数使用详解>>有关于epoll函数的讲解. 一.epoll 系列函数简介 #include <sys/epoll.h&gt ...

  10. 学习经验分享(最近听了一节Java公开课)

    最近听了一节Java公开课,讲的Tomcat8.0的,老师分享的学习方法很好, 时间和精力要用对地方 1.学习一个知识的广度和深度,先学主要的主流的,不要学了很多不该学,没必要学的东西 2.要花时间总 ...