共查询到19条相似文献,搜索用时 156 毫秒
1.
工程技术人员在Web页面通过OWC Spreadsheet在线输入数据、计算数据和保存数据.虽然企业一般在计算模板中定义了格式规范,以某种规则表明该单元格的编辑方式--输入或选择或不能编辑,但是Spreadsheet的单元格可以自由输入数据,容易产生人为错误,可能破坏XML表格内容.本文假定企业使用单元格底纹表明编辑形式,在VS.Net 2005开发环境下对Spreadsheet做了改进,采用ATL复合控件的方法对Spreadsheet、文本框、下拉列表框等控件进行封装,新生成的控件可根据单元格底纹限制工程技术人员只能在文本框中输入、下拉列表框中选择或者不能编辑,避免误操作,保护XML表格内容,提高工作效率. 相似文献
2.
一、取消单元格合并 在Excel中单元格的合并可以使用格式工具栏中的“合并及居中”按钮来实现,但它不像“加粗”等按钮那样具备开/关功能,只能合并,而不能取消合并。而实际操作过程中合并后的单元格有时又需要将其拆分开来,恢复成未合并前的格式,如果此时工作簿已经保存,是无法使用“撤消”命令撤消的,此时可以使用以下操作方法来取消单元格的合并: 1、用鼠标单击要取消合并的单元格。 相似文献
3.
在分析和比较数据时,我们很有可能会用到电子表格Excel 97这一办公室必备软件来绘制表格。在使用Excel 97时,不知您是否留意到在选定的活动单元格或区域的右下角有一黑色方块,它的名字叫填充柄,利用它可进行快速操作从而提高工作效率。如果在您的表格中看不到这个黑色方块,则可选择菜单栏的“工具/选项.../编辑”中为“单元格拖曳功能”,将其前面打上“√”,然后点击“确定”按钮退出,以后每当用鼠标指向填充柄时,鼠标指针将会由白色十字光标或箭头改变为黑色十字光标。 相似文献
4.
VBA在多Excel工作薄数据汇总的应用 总被引:1,自引:0,他引:1
利用Excel进行数据处理分析时,常需要对大量独立的具有相同表结构的原始工作薄中的数据进行汇总合并到一个工作薄的指定工作表中。通过VBA编程调用Excel对象在不打开源工作薄的情况下,将指定文件夹中所有工作薄中的某一工作表的数据汇总合并,并添加工作薄文件名称字段表明数据来源。可以将需要一天或几天重复性的打开-复制-粘贴等操作才能完成的任务,缩短为几分钟完成。 相似文献
5.
Excel是当前数据处理中常用的软件,虽然自由编程可以使应用程序具备Excel的功能,但是比较复杂,且实现比较困难。介绍了集成Excel技术的概况,并对三种集成Excel的方法进行了比较和探讨。利用集成Excel技术简化应用程序编程,从而使应用程序设计与实现更加容易,使用更加方便。使用automation对象及控件集成Excel具有明显优势,而控件集成相对更简单。这里对每种方法均辅以详细的步骤,有利于集成Excel技术的推广和应用。 相似文献
6.
贾志先 《智能计算机与应用》2015,(1):48-52
在Excel VBA课程考试软件开发中,如何从Excel文件中获取考生操作的窗体对象和宏代码,是操作题评分中的一个关键性问题。到目前为止,有关Excel VBA课程的考试软件开发和评分方法研究方面的文献报道尚不多见。利用VBE及其子对象的属性和方法,可以测试Excel VBA工程中的窗体和控件对象的属性和事件代码,以及模块中的宏代码。给出了基本操作题、程序改错题和程序填空题这三种题型的试题和答案设计的示例。考试结果表明,使用VBE对象来获取考生操作的窗体对象和宏代码,很好地解决了Excel VBA考试系统中操作题的计算机评分问题。 相似文献
7.
8.
李云峰 《电子产品维修与制作》2010,(12):40-40
有一次,我运行了一个从网上下载的使用Excel制作的系统后,Excel 2003中右键单击单元格或其他区域,不会弹出右键菜单,并且连菜单栏也没有了(如图4)。 相似文献
9.
对于一个非常庞大的Excel文件,有时我们仅仅需要某几个单元格中的信息,这时就希望能够做到指向哪里就读取哪里。本文介绍一种可读取Excel文件中任何一个指定单元格的方法。 相似文献
10.
在Excel单元格内输入数据时,您是否为如何杜绝或减少录入数据出错的可能性,最大限度地保证数据的真实、有效颇伤脑筋?其实,微软的Office功能相当强大,只要您深入了解,就能发现许多实用的东东。下面,笔者根据自己的使用经验,简要介绍如何运用Excel内置的“有效性”命令来验证输入数据的有效性。 相似文献
11.
M. O. Esonu A. J. Al-Khalili S. Hariri D. Al-Khalili 《The Journal of VLSI Signal Processing》1995,11(1-2):151-168
A systematic approach of designing fault-tolerant systolic architectures is proposed in this paper. In this approach, redundant computations are introduced at the algorithmic level by deriving three versions of a given algorithm. Fault-tolerant systolic array is constructed by merging the corresponding systolic array of the three versions of the algorithm. The merging method attempts to obtain the fault-tolerant systolic array at minimal cost in terms of area and speed. It is based on rescheduling input data, rearranging data flow, and increasing the utilization of the array cells. The resulting design can detect and tolerate all single permanent and temporary faults and the majority of the multiple fault patterns with high probability. 相似文献
12.
A method of designing testable systolic architectures is proposed in this paper. Testing systolic arrays involves mapping of an algorithm into a specific VLSI systolic architecture, and then modifying the design to achieve concurrent testing. In our approach, redundant computations are introduced at the algorithmic level by deriving two versions of a given algorithm. The transformed dependency matrix (TDM) of the first version is a valid transformation matrix while the second version is obtained by rotating the first TDM by 180 degrees about any of the indices that represent the spatial component of the TDM. Concurrent error detection (CED) systolic array is constructed by merging the corresponding systolic array of the two versions of the algorithm. The merging method attempts to obtain the self testing systolic array at minimal cost in terms of area and speed. It is based on rescheduling input data, rearranging data flow, and increasing the utilization of the array cells. The resulting design can detect all single permanent and temporary faults and the majority of the multiple fault patterns with high probability. The design method is applied to an algorithm for matrix multiplication in order to demonstrate the generality and novelty of our approach to design testable VLSI systolic architectures.This work has been supported by a grant from the Natural Sciences and Engineering Research Council of Canada. 相似文献
13.
14.
15.
Ninad Thakoor Jean Gao Venkat Devarajan 《IEEE transactions on image processing》2008,17(11):2217-2226
An iterative split-and-merge framework for the segmentation of planar surfaces in the disparity space is presented. Disparity of a scene is modeled by approximating various surfaces in the scene to be planar. In the split phase, the number of planar surfaces along with the underlying plane parameters is assumed to be known from the initialization or from the previous merge phase. Based on these parameters, planar surfaces in the disparity image are labeled to minimize the residuals between the actual disparity and the modeled disparity. The labeled planar surfaces are separated into spatially continuous regions which are treated as candidates for the merging that follows. The regions are merged together under a maximum variance constraint while maximizing the merged area. A multistage branch-and-bound algorithm is proposed to carry out this optimization efficiently. Each stage of the branch-and-bound algorithm separates a planar surface from the set of spatially continuous regions. The multistage merging estimates the number of planar surfaces and their labeling. The splitting and the multistage merging is repeated till convergence is reached or satisfactory results are achieved. Experimental results are presented for variety of stereo image data. 相似文献
16.
针对目前Excel与数据库间的数据交换方法通用性不够的问题,对Excel表单中各逻辑子表的关联关系,以及Excel、应用程序、数据库表三者之间的关系进行了分析,提出了基于语法规则的通用数据交换方法。通过设计一套用于数据交换的语法规则,然后建立解释器解释该规则,便可完成他们间的双向数据沟通。应用证明,该方法具有很好的通用性。 相似文献
17.
Birk A. Carpin S. 《Proceedings of the IEEE. Institute of Electrical and Electronics Engineers》2006,94(7):1384-1397
Mapping can potentially be speeded up in a significant way by using multiple robots exploring different parts of the environment. But the core question of multirobot mapping is how to integrate the data of the different robots into a single global map. A significant amount of research exists in the area of multirobot mapping that deals with techniques to estimate the relative robots poses at the start or during the mapping process. With map merging, the robots in contrast individually build local maps without any knowledge about their relative positions. The goal is then to identify regions of overlap at which the local maps can be joined together. A concrete approach to this idea is presented in form of a special similarity metric and a stochastic search algorithm. Given two maps m and m', the search algorithm transforms m' by rotations and translations to find a maximum overlap between m and m'. In doing so, the heuristic similarity metric guides the search algorithm toward optimal solutions. Results from experiments with up to six robots are presented based on simulated as well as real-world map data. 相似文献
18.
《Selected Areas in Communications, IEEE Journal on》2009,27(2):143-155
The increasing amount of bandwidth requirements and quality of service needs for the next-generation access networks has boosted extensive research in the fiber-optics communication field. In this light, passive optical networks (PONs) combined with optical code division multiple access (OCDMA), provide a potentially cost-effective solution to meet such bandwidth demands. This work proposes an optical transparent architecture which enables all-optical communication between the network nodes. The encoded data streams are multiplexed at a merging point which results in multiple user interference (MUI), thus significantly reducing the network throughput. The networking nodes are able to monitor and record user activity in the PON, and further register the (past) state of activity at the merging point. In this work, we study the coherence of state between the networking nodes and the merging point, for different packet size distributions, in order to predict an optimal transmission instant of each node's data packets. We note that the states are coherent depending on the packet size distribution. 相似文献
19.
微软的Office办公系统在计算机应用中是十分广泛的,尤其是它的Excel和Word,如果能将数据库里的数据直接在Excel和Word中显示,不仅能方便不懂数据库的操作人员查看数据,而且能将数据普及化,还能大大节省数据的操作时间。本文就以Oracle数据库为例,通过VB将数据显示在Excel和Word中。 相似文献